Postgres Pro
Downloads
Home   >   mailing lists

Re: Querying a Large Partitioned DB - Mailing list pgsql-general

From Tom Lane
Subject Re: Querying a Large Partitioned DB
Date
Msg-id 23276.1239376722@sss.pgh.pa.us
Whole thread Raw
In response to Querying a Large Partitioned DB  (Justin Funk <funkju@iastate.edu>)
List pgsql-general
Tree view 
Justin Funk <funkju@iastate.edu> writes:
> Can you give me any tips and suggestions about how to speed this up?

Use fewer partitions --- 180 is a lot.  Maybe weekly partitioning would
be about right.

            regards, tom lane

pgsql-general by date:

Previous
From: "Dann Corbit"
Date:
Subject: Re: INSERT or UPDATE
Next
From: Bruce Momjian
Date:
Subject: Re: Evidently no support for the mmddyyyy date format