Re: genomic locus

2017-12-19 Thread Andrey Zhidenkov
Uncertain type is a great idea. I needed type like this to store information about premiere date or people birth date in movie database. Finally I made two columns: and . Precocious could me 'year', 'month' and so on and if precocious was 'year' the date should always had to be like '-01-01'.

Re: Notes about Pl/PgSQL assignment performance

2017-12-19 Thread Andrey Zhidenkov
) and PopActiveSnapshot() wich just do memory context allocations and use malloc() to copy snaphot. Maybe I have missed something? On Tue, Dec 19, 2017 at 4:34 PM, Alvaro Herrera wrote: > Andrey Zhidenkov wrote: > > When I run this test in 2 threads I expect that running time will be

Re: Notes about Pl/PgSQL assignment performance

2017-12-19 Thread Andrey Zhidenkov
When I run this test in 2 threads I expect that running time will be the same, because PostgreSQL will fork process for the second connection and this process will be served by a separate CPU core because I have more than 2 cores. Yes, IMMUTABLE flag helps, but I think It's just because Postgres ac