Re: [GENERAL] Create/Erase 5000 Tables in PostGRE SQL in execution

2006-01-17 Thread Sergey Moiseev
eed to be sure that you > vacuum the right things :-). Since there is pg_autovacuum you don't need to think about it. -- Wbr, Sergey Moiseev ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

Re: [GENERAL] Create/Erase 5000 Tables in PostGRE SQL in execution

2006-01-16 Thread Sergey Moiseev
a table in PostGRESQL I use > it and then I erase it. Is a system efficient this way? Is it possible > to have 5000 tables in PostGRESQL? How much performance? > Use TEMP tables. -- wbr, Sergey Moiseev ---(end of broadcast)--- TIP 4: Ha

Re: [GENERAL] getting last day of month

2005-08-25 Thread Sergey Moiseev
Sergey Pariev wrote: > Hi all. > I need to find out the last day of current month. Currently I do the > trick with code below, but that's rather ugly way to do it IMHO. Could > anybody suggest me a better way ? select '2005-09-01'::date-'1 day'::interval does