Re: [PERFORM] PGSQL 9.3 - billion rows

2014-07-08 Thread Josh Berkus
On 07/07/2014 06:59 AM, Nicolas Paris wrote: > - Can postgresql support such table (this table is the fact table of a > datamart -> many join query with dimensions tables) ? Yes, it can. > - If yes, I would like to test (say insert 2 billion test rows), what > serveur configuration do I need ? Ho

Re: [PERFORM] DB sessions 100 times of DB connections

2014-07-08 Thread Steve Crawford
On 07/03/2014 06:59 PM, Huang, Suya wrote: BTW, I'm using the pgbadger report to check for peak connections/sessions. *From:*pgsql-performance-ow...@postgresql.org [mailto:pgsql-performance-ow...@postgresql.org] *On Behalf Of *Huang, Suya *Sent:* Friday, July 04, 2014 11:44 AM *To:* pgsql-per