Events Add an event Speakers Talks Collections
 
Duration 03:51
16+
Play
Video

PGConf India 2020 - Lightning Talk - Astrology & PostgreSQL timestamptz - Ashutosh B - 2ndQuadrant

Ashutosh Bapat
Senior PostgreSQL Architect at EDB
  • Video
  • Table of contents
  • Video
PGConf India, 2020
February 26, 2020, Bengaluru, India
PGConf India, 2020
Request Q&A
PGConf India, 2020
From the conference
PGConf India, 2020
Request Q&A
Video
PGConf India 2020 - Lightning Talk - Astrology & PostgreSQL timestamptz - Ashutosh B - 2ndQuadrant
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free
Add to favorites
20
I like 0
I dislike 0
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free
  • Description
  • Transcript
  • Discussion

About the talk

About speaker

Ashutosh Bapat
Senior PostgreSQL Architect at EDB

Long experience in the field of core database server development in the areas like storage, buffer manager, query processing and optimization. Special exposure to distributed database servers. Ability to adapt to the work cultures from world class large organizations like Sybase to start-ups like EnterpriseDB. Good experience in customer interaction at various levels, representing organization at conferences, technical talks and marketing events.

View the profile
Share

So the lightning bugs are, I mean, if you have gone to physical and conferences in other areas are there, parts of wild? Dogs are mean to take you to a million different subject. I'm trying to do that cheered by connecting astrology, which is far removed, from what we do every day was great and connecting with a sequel. So will I, are you supposed to receive full for doing my astrological research and trying to do some analysis on astrological. So what I do, I use it for I store and grocery budget is the basic things we have to do for any astrological.

And then I also use it to store properties of Transit suspects and mini complex things that astrology works with. Like if you know what the progression since when has offered So quickly the data grows in GPS even with few hundred people data. And obviously I do it for my personal training so I don't have that luxury of having bigger workstations and so on. So I do this on a 4GB ram laptop with HDD. Not even is dead and everything is running on the same. Now, the beauty of was receivable is it just ran around

mini complex, queries with Charlie data mining queries data analytics on top of your birthday at the end of crazy that you give me results which I can use for them. No, the only problem that I hit with was going to sleep well and truly, this is a problem that should be fixed in post with equal is astrology, a paraphernalia of zodiac planets. The properties is essentially a science of space and time dealing with these two things and trying to predict something out of doors. And the time here is actually evolving time based on your local time. So

the time of the time zone Where You Are, Unfortunately, when you want to store postgres time in postgres equal, even if you use time-stamped either, which is x * width * own, it removes the time zone part of it, and convert it into your UTC and says, it has a utility UTC time. So when you want it to be reported back, its reports in the time zone where the database server is running. So if I have some data or sometime because us time and I'm reading my application locally in India.

All the time that it's going to give me is Indian time and not us time and then I have to store. But in time zone across the globe events across the globe, have to do all the time at metal-matic application, which is very calm person, given all the complexities there. And not just astrology. This is a real problem when you are migrating from Oracle to receive the time zone, where I supposed to receive that something that was received. Until 6 sometime. Thank you.

Cackle comments for the website

Buy this talk

Access to the talk “PGConf India 2020 - Lightning Talk - Astrology & PostgreSQL timestamptz - Ashutosh B - 2ndQuadrant”
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free

Standart

Get access to all videos “PGConf India, 2020”
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free
Ticket

Interested in topic “IT & Technology”?

You might be interested in videos from this event

November 9 - 17, 2020
Online
50
21
future of ux, behavioral science, design engineering, design systems, design thinking process, new product, partnership, product design, the global experience summit 2020, ux research

Similar talks

Ivan Panchenko
Deputy CEO at Postgres Professional
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free
Denis Mekhanikov
Software Engineer at Facebook
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free
Ajay Kumar
Assistant Engineer at Kerala State Electricity Board
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free

Buy this video

Video
Access to the talk “PGConf India 2020 - Lightning Talk - Astrology & PostgreSQL timestamptz - Ashutosh B - 2ndQuadrant”
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free

Conference Cast

With ConferenceCast.tv, you get access to our library of the world's best conference talks.

Conference Cast
842 conferences
34129 speakers
12910 hours of content