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
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:
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
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
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
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
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
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...
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
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
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
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
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?
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
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
15 matches
Mail list logo