date" btree (end_date)
"agg_t377_incoming_a40_dst_net_f5_start_date" btree (start_date)
Thanks for your help,
Sylvain
- Mail original -
> On 10/16/2012 03:50 PM, Sylvain CAILLET wrote:
> > Hi to all,
> >
> > I've got a trouble with some delete statements. M
clause of your DELETE statement doesn't make use of
> your start and end date columns ? If so, in which order ?
> Please, provide with your Pg version and the table setup with the
> index.
> Regards,
> Sekine
> 2012/10/16 Sylvain CAILLET < scail...@alaloop.com &g
ch a query per table ! Not good at all.
Thank you all, I will optimize this.
Sylvain
- Mail original -
> On Sun, Jul 8, 2012 at 11:49 PM, Sylvain CAILLET
> wrote:
> > Hi,
> >
> > Thank you all for your help.
> >
> > @Jeff : my daemon creates these tab
it's done in less than a
second. Autovacuum is on but not tuned in postgresql configuration file.
Sylvain Caillet
----- Mail original -
On 07/06/2012 11:15 PM, Sylvain CAILLET wrote:
Hi to all,
I run Postgresql 8.3.9 on a dedicated server running with Debian 5.0.4, a
Hi to all,
I run Postgresql 8.3.9 on a dedicated server running with Debian 5.0.4, a
strong bi quad-proc with RAM 16Go. My biggest db contains at least 100 000
tables. Last time, I started a Java process I use to make some change on it, it
created 170 new tables and it took one full minute.
