[GENERAL] equivalent in postgres of over(partition) function in db2

2005-02-23 Thread vinita bansal
Hi, I have the following query in db2: insert into xyz (a,b) select 10, MIN(CM_LEDGERITEM.tril_gid) OVER(PARTITION BY CM_LEDGERITEM.MMPAYEE, CM_PROMOTION.MMCOMPTYPE, CM_LEDGERITEM.MODEL) from I am not able to find a corresponding thing for min(...) over(partition by col1, col2, col3..) in

Re: [GENERAL] stats collector appears to be dying

2005-02-23 Thread Tom Lane
Shelby Cain [EMAIL PROTECTED] writes: I'm having an issue with what appears to be the stats collector process dying on Postgresql 8.0.1 running on Windows XP w/sp1. 2005-02-23 14:59:17 FATAL: could not read from statistics collector pipe: No such file or directory 2005-02-23 14:59:17 LOG:

Re: [GENERAL] [PATCHES] A way to let Vacuum warn if FSM settings are low.

2005-02-23 Thread Tom Lane
Ron Mayer [EMAIL PROTECTED] writes: +if (needed MaxFSMPages) +ereport(WARNING, +(errmsg(max_fsm_pages(%d) is smaller than total pages needed(%.0f), + MaxFSMPages, needed))); An unconditional WARNING seems a bit strong to me for a case that is not

Re: [GENERAL] multiple runs of the same query cause out of memory - WAS [Re: capturing/viewing sort_mem utilization on a per query basis]

2005-02-23 Thread Tom Lane
Lonni J Friedman [EMAIL PROTECTED] writes: We have found that this query can indeed cause terrible things to happen to postgresql - it can run several times with response times of a few seconds, and then the next time cause postgres to go out of control on memory usage. (I've had to reboot my

Re: [GENERAL] multiple runs of the same query cause out of memory - WAS [Re: capturing/viewing sort_mem utilization on a per query basis]

2005-02-23 Thread Lonni J Friedman
On Wed, 23 Feb 2005 19:56:56 -0500, Tom Lane [EMAIL PROTECTED] wrote: Lonni J Friedman [EMAIL PROTECTED] writes: We have found that this query can indeed cause terrible things to happen to postgresql - it can run several times with response times of a few seconds, and then the next time

[GENERAL] multiple runs of the same query cause out of memory - WAS [Re: capturing/viewing sort_mem utilization on a per query basis]

2005-02-23 Thread Lonni J Friedman
List Tom, Following up on this thread from a weeks ago: http://archives.postgresql.org/pgsql-general/2005-02/msg00106.php We have found that this query can indeed cause terrible things to happen to postgresql - it can run several times with response times of a few seconds, and then the next time

Re: [GENERAL] Emacs and postgres

2005-02-23 Thread Greg Stark
Sean Davis [EMAIL PROTECTED] writes: This is a bit off-topic Does anyone know of an interface between emacs and psql? I currently use it as my default editor and do my share of save and then \i. I just gave pgEdit a try and liked many aspects of it, but I still like Emacs as an

[GENERAL] Seguimos buscando webdeveloper...

2005-02-23 Thread Cristian Prieto
Aunque parezca increible, seguimos buscando webdeveloper, se ofrece buen sueldo y excelente ambiente de trabajo. Patojo, vos me dijiste que tenias a alguien, que paso? Si alguien mas esta interesado (el sueldo es en $) porfavor, porfavor, envienme un correo... Xaludos...

Re: [GENERAL] Recovering db from cracked server

2005-02-23 Thread Don Doumakes
Richard Huxton wrote: You're close - the only thing it was complaining about was the missing postgres database. That's because it defaults to using the same database as the username. Try postgres -D copy_of_old_data_dir template1 Or use the name of your old database. Woohoo! Thanks a

Re: [GENERAL] Ways to speed up dumpreload

2005-02-23 Thread Vivek Khera
max out your checkpoint_segments. 128 or 256 is good if you have plenty of spare space for the pg_xlog directory. you will also want to increase checkpoint_timeout to something large. I like 900 seconds personally. if you can put pg_xlog on a separate physical RAID you're best off. increase

[GENERAL] Tracking down cause of duplicated oid in table.

2005-02-23 Thread Jared Carr
We have a table that we use to store aggregated data, nightly we add a row for the previous day, and update all the rows in the table with the new information. The table is then vacuumed full. Our setup is: Linux Kernel 2.6.4 SCSI Drives Hardware Raid 10 (4 Drives) Reiserfs PostgreSQL 7.4.5 The

[GENERAL] maximum size

2005-02-23 Thread Molinet Sylviane
Hello, could you be so kind to help me with following requests ? I need the maximum size of the following types : varchar(n) numeric(n,p) text bytea Could you please give me the name of articles or publications and where I can find it for these requests ? I want to transfer a oracle database 8i

[GENERAL] Help with tools...

2005-02-23 Thread Cristian Prieto
I've tryied with some tools as pgEditor and EMS PostgreSQL Manager, but I need a really good pgsql and database Editor to use in Linux or Windows. Options?

[GENERAL] Pg 8.0rc5 to 8.0.1 update

2005-02-23 Thread Ben Trewern
Hi, Just a quick question. Do I need to do an initdb to upgrade a cluster from v8.0rc5 to v8.0.1 or can I just do a make install. TIA Ben ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [GENERAL] Help with tools...

2005-02-23 Thread Jason Earl
Cristian Prieto [EMAIL PROTECTED] writes: I've tryied with some tools as pgEditor and EMS PostgreSQL Manager, but I need a really good pgsql and database Editor to use in Linux or Windows. Options? Have you take a look at pgAdmin III? http://www.pgadmin.org/ What sort of features are you