Re: [GENERAL] "Stuck" query

2008-09-10 Thread Tommy Gildseth
Erik Jones wrote: On Sep 10, 2008, at 5:57 AM, Tommy Gildseth wrote: Tom Lane wrote: Tommy Gildseth <[EMAIL PROTECTED]> writes: Richard Huxton wrote: For what it's worth, I've run into a situation similar to this with a client a couple time in the last week or two (I can't say identical a

[GENERAL] How to check if an array is empty

2008-09-10 Thread Tobias Anstett
Hi, in my special case I'd like to check if a XML[] is empty, because postgres doesn't implement any equality operators, this is not a 'simple' task. My current solution is: SELECT * FROM sometable WHERE XMLSERIALIZE(CONTENT ((XPATH('/a:bar, somexmlcolumn, ARRAY[ARRAY['a', 'http://foo]]

Re: [GENERAL] psql scripting tutorials

2008-09-10 Thread Greg Smith
On Tue, 9 Sep 2008, Artacus wrote: Can psql access environmental variables or command line params? $ cat test.sql select :TEST as "input"; $ psql -v TEST=16 -f test.sql input --- 16 (1 row) You can find out more about what you can do with variable substitution at http://www.postgres

Re: [GENERAL] No error when column doesn't exist

2008-09-10 Thread Artacus
I expected that to generate an error: column foo.text does not exist. Instead it treats "foo.text" as "foo.*::text AS text": Is this a feature or a bug? Hmm. It's a feature, but maybe a dangerous one. The expression is being treated as text(foo), which is intentional in order to allow use of f

Re: [GENERAL] abusing plpgsql array variables

2008-09-10 Thread Artacus
If I want to pass in a text[] argument to a plpgsql function, at what array size am I asking for problems? 100? 10,000? 100,000? What severity of problems might I encounter? Bad performance? Postgres refusing to run my query? A crashed backend? Yeah, like you I was pretty worried about how

Re: [GENERAL] using a GUI front end to postgres

2008-09-10 Thread Artacus
What's the best open-source front-end for rapid GUI query and report generation using postgres? Is it possible to use MS access as a front-end to postgres for rapid prototyping? Can that be done through ODBC? This question was asked about a week ago. I don't recall all of the answers but I

Re: [GENERAL] psql scripting tutorials

2008-09-10 Thread Scott Marlowe
On Wed, Sep 10, 2008 at 10:14 PM, Artacus <[EMAIL PROTECTED]> wrote: >> This sounds a lot like what I did in my last job using bash for most >> things, and php for the more complicated stuff. Wrote a simple oracle >> to pgsql table replicator in php that worked pretty well. > > Well we do this stu

[GENERAL] using a GUI front end to postgres

2008-09-10 Thread Darren Weber
What's the best open-source front-end for rapid GUI query and report generation using postgres? Is it possible to use MS access as a front-end to postgres for rapid prototyping? Can that be done through ODBC? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] psql scripting tutorials

2008-09-10 Thread Artacus
This sounds a lot like what I did in my last job using bash for most things, and php for the more complicated stuff. Wrote a simple oracle to pgsql table replicator in php that worked pretty well. Well we do this stuff all the time with Oracle and sql*plus. And I've heard people hear say about

Re: [GENERAL] postgres user account on OSX

2008-09-10 Thread kevin kempter
On Linux if you install postgres via RPM's and the postgres user account does not exist then the RPM install creates it for you and sets the home dir to the root for the postgres binaries (i.e. /var/lib/ pgsql) Maybe the same thing happens on a Mac install ? On Sep 10, 2008, at 5:14 PM, Da

[GENERAL] Trigger for insert/update of BLOB's ?

2008-09-10 Thread kevin kempter
Hi List; Can I create an insert/update trigger based on a table that contains lo_* style BLOB's ? Thanks in advance -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] initdb memory segment creation error

2008-09-10 Thread questions
I am getting this error with initdb while creating shared segment - "memory segment exceeded available memory or swap space. To reduce the request size (currently 1785856 bytes), reduce PostgreSQL's shared_buffers parameter (currently 50)) and/or its max_connections parameter (currently 13)." Tota

Re: [GENERAL] postgres user account on OSX

2008-09-10 Thread Shane Ambler
Tom Lane wrote: "Darren Weber" <[EMAIL PROTECTED]> writes: There is a postgres user account on my OSX system. I'm not clear about how it was created. I've installed a binary version of 8.3 in /Library/PostgreSQL/8.3/ and built another version from source into /usr/local/pgsql/. When I login a

Re: [GENERAL] Server installation problem using freebsd ports

2008-09-10 Thread Mohd Fahadullah
Thanks, it was a freebsd ports problem. Sorry for sending it on this list. On Wed, Sep 10, 2008 at 6:01 AM, Bill Moran <[EMAIL PROTECTED]>wrote: > In response to "Artis Caune" <[EMAIL PROTECTED]>: > > > On Tue, Sep 9, 2008 at 9:21 AM, Mohd Fahadullah <[EMAIL PROTECTED]> > wrote: > > > Hi, > > > >

Re: [GENERAL] abusing plpgsql array variables

2008-09-10 Thread Merlin Moncure
On Wed, Sep 10, 2008 at 4:03 PM, Ben <[EMAIL PROTECTED]> wrote: > If I want to pass in a text[] argument to a plpgsql function, at what array > size am I asking for problems? 100? 10,000? 100,000? > > What severity of problems might I encounter? Bad performance? Postgres > refusing to run my query?

Re: [GENERAL] postgres user account on OSX

2008-09-10 Thread Tom Lane
"Darren Weber" <[EMAIL PROTECTED]> writes: > There is a postgres user account on my OSX system. I'm not clear > about how it was created. I've installed a binary version of 8.3 in > /Library/PostgreSQL/8.3/ and built another version from source into > /usr/local/pgsql/. When I login as root and

[GENERAL] postgres user account on OSX

2008-09-10 Thread Darren Weber
There is a postgres user account on my OSX system. I'm not clear about how it was created. I've installed a binary version of 8.3 in /Library/PostgreSQL/8.3/ and built another version from source into /usr/local/pgsql/. When I login as root and then 'su - postgres' it takes me to the postgres ac

Re: [GENERAL] pgdump problem or question?

2008-09-10 Thread Scott Marlowe
On Wed, Sep 10, 2008 at 3:31 PM, Bayless Kirtley <[EMAIL PROTECTED]> wrote: > Early Friday morning a bad record caused me to reload the Thursday night > pgdump backup. I performed a pgdump first to study later. In the backup I > found several incomplete transactions all done at the end of the day.

Re: [GENERAL] PostgreSQL process architecture question.

2008-09-10 Thread Reece Hart
On Wed, 2008-09-10 at 00:02 -0600, Scott Marlowe wrote: > Unless you have either a small data set or a very powerful RAID array, > most the time you won't be CPU bound anyway. But it would be nice to > see some work come out to parallelize some of the work done in the > back end. I would have a

[GENERAL] pgdump problem or question?

2008-09-10 Thread Bayless Kirtley
Early Friday morning a bad record caused me to reload the Thursday night pgdump backup. I performed a pgdump first to study later. In the backup I found several incomplete transactions all done at the end of the day. Investigating later I found the original bad record from the Friday dump and fi

Re: [GENERAL] PostgreSQL process architecture question.

2008-09-10 Thread Chris Browne
[EMAIL PROTECTED] ("Amber") writes: >We know PostgreSQL uses one dedicated server process to serve one > client connection, what we want to know is whether PostgreSQL use > multiple threads inside agents processes to take advantage of > multiple CPUs. In our site we have only a few concurren

Re: [ADMIN] [GENERAL] FW: How to upload data to postgres

2008-09-10 Thread Ben Kim
From: "Markova, Nina" <[EMAIL PROTECTED]> I also plan to try to export data in XML format (from Ingres) and import it to Postgres. I didn't find any utility for importing XML data into Postgres. You can possibly use perl's XML::Xpath for XML import (DBIx::XML_RDB for export), assuming the tab

Re: [GENERAL] RV: You need to rebuild PostgreSQL using --with-libxml.

2008-09-10 Thread Scott Marlowe
Please configure your MTA to either just drop email from people you don't know or let it through. Sending off an error message saying my email's rejected for policy is kinda rude on a public mailing list. If everyone did it my email box would double in size. On Wed, Sep 10, 2008 at 2:04 PM, Ricar

Re: [GENERAL] RV: You need to rebuild PostgreSQL using --with-libxml.

2008-09-10 Thread Scott Marlowe
On Wed, Sep 10, 2008 at 2:04 PM, Ricardo Antonio Yepez Jimenez <[EMAIL PROTECTED]> wrote: > > > Hi, > > As I compile postgresql 8.3.2 to support sql / xml, Red hat 5.1 enterprise > edition, I need to know the steps to configure, if someone owns a manual. xml support is built in now isn't it? And

[GENERAL] RV: You need to rebuild PostgreSQL using --with-libxml.

2008-09-10 Thread Ricardo Antonio Yepez Jimenez
Hi, As I compile postgresql 8.3.2 to support sql / xml, Red hat 5.1 enterprise edition, I need to know the steps to configure, if someone owns a manual. Thank you. .

[GENERAL] abusing plpgsql array variables

2008-09-10 Thread Ben
If I want to pass in a text[] argument to a plpgsql function, at what array size am I asking for problems? 100? 10,000? 100,000? What severity of problems might I encounter? Bad performance? Postgres refusing to run my query? A crashed backend? -- Sent via pgsql-general mailing list (pgsql-ge

Re: [GENERAL] psql scripting tutorials

2008-09-10 Thread Scott Marlowe
On Wed, Sep 10, 2008 at 12:46 AM, Artacus <[EMAIL PROTECTED]> wrote: > Artacus wrote: >> >> I'd like to learn a little more about writing psql scripts does anyone >> know of any resources outside of the manual? > > Ok then. Does anyone have any tips or best practices for scripting psql? > > I'll pr

Re: [GENERAL] 64-bit Compile Failure on Solaris 10 with OpenSSL

2008-09-10 Thread Zdenek Kotala
Randal T. Rioux napsal(a): On Mon, September 8, 2008 9:38 am, Randal T. Rioux wrote: Found a kludgy fix! cp /usr/local/lib/sparcv9/libgcc_s.so.1 /usr/sfw/lib/sparcv9/ Now, both OpenSSL and PostgreSQL work great. In 64-bit mode. If anyone has a less hack-ish solution, please share. try to

Re: [GENERAL] 64-bit Compile Failure on Solaris 10 with OpenSSL

2008-09-10 Thread Zdenek Kotala
Randal T. Rioux napsal(a): On Wed, September 10, 2008 10:54 am, Zdenek Kotala wrote: I just don't like the Solaris package system in general. It is, dare I say, worse than RPM. But this is a PostgreSQL list, so I'll save the rant! Community solaris "package" on postgresql download website i

Re: [GENERAL] No error when column doesn't exist

2008-09-10 Thread Tom Lane
Dean Rasheed <[EMAIL PROTECTED]> writes: > CREATE TABLE foo(a int, b int); > INSERT INTO foo VALUES(1,2); > SELECT foo.text FROM foo; > I expected that to generate an error: column foo.text does not exist. > Instead it treats "foo.text" as "foo.*::text AS text": > Is this a feature or a bug? Hmm.

Re: [GENERAL] FW: How to upload data to postgres

2008-09-10 Thread Markova, Nina
Adrian, The trick seems to work. Thanks! Nina -Original Message- From: Adrian Klaver [mailto:[EMAIL PROTECTED] Sent: September 10, 2008 11:58 To: Markova, Nina Cc: pgsql-general@postgresql.org; [EMAIL PROTECTED] Subject: RE: [GENERAL] FW: How to upload data to postgres --- Or

Re: [GENERAL] Can interval take a value from a field?

2008-09-10 Thread Jeff Ross
Jeff Davis wrote: On Tue, 2008-09-09 at 17:03 -0600, Jeff Ross wrote: select ts_date as "Transcript Date", ts_expiration_date as "Current Expiration Date", expiration_value as "Expiration Interval" from transcript, training_expiration_value where ts_t

[GENERAL] No error when column doesn't exist

2008-09-10 Thread Dean Rasheed
I've just spent a couple of hours tracking down a bug which turned out to be a typo in my code. What surprises me is that the SQL in question didn't immediately produce an error. Here's a simplified example: CREATE TABLE foo(a int, b int); INSERT INTO foo VALUES(1,2); SELECT foo.text FROM foo; I

Re: [GENERAL] 64-bit Compile Failure on Solaris 10 with OpenSSL

2008-09-10 Thread Andy Colson
Randal T. Rioux wrote: Found a kludgy fix! cp /usr/local/lib/sparcv9/libgcc_s.so.1 /usr/sfw/lib/sparcv9/ Now, both OpenSSL and PostgreSQL work great. In 64-bit mode. If anyone has a less hack-ish solution, please share. Thanks! Randy Not sure if this'll make it to the list or not, I'm not

Re: [GENERAL] What's size of your PostgreSQL Database?

2008-09-10 Thread Joshua Drake
On Wed, 10 Sep 2008 23:33:44 +0800 "Amber" <[EMAIL PROTECTED]> wrote: > Yes, we know both Greenplum and Netezza are PostgreSQL based MPP > solutions, but they are commercial packages. I'd like to know are > there open source ones, and I would suggest the PostgreSQL Team to > start a MPP version o

Re: [GENERAL] FW: How to upload data to postgres

2008-09-10 Thread Adrian Klaver
--- Original message -- From: "Markova, Nina" <[EMAIL PROTECTED]> > > I also plan to try to export data in XML format (from Ingres) and import > it to Postgres. > > I didn't find any utility for importing XML data into Postgres. Or just > looking at the wrong documen

Re: [GENERAL] "Stuck" query

2008-09-10 Thread Erik Jones
On Sep 10, 2008, at 5:57 AM, Tommy Gildseth wrote: Tom Lane wrote: Tommy Gildseth <[EMAIL PROTECTED]> writes: Richard Huxton wrote: Looks like part of your query results being sent. Is it hung in that one system-call? Yes, I left it there for about ~1 hour, and that was all that ever cam

Re: [GENERAL] You need to rebuild PostgreSQL using --with-libxml.

2008-09-10 Thread Devrim GÜNDÜZ
On Wed, 2008-09-10 at 08:57 -0430, Ricardo Antonio Yepez Jimenez wrote: > As I compile postgresql 8.3.2 If this is not a typo, please use 8.3.3 . > to support sql / xml, Red hat 5.1 > enterprise edition, I need to know the steps to comfigurarlo Why don't you use precompiled packages for RHEL +

Re: [GENERAL] 64-bit Compile Failure on Solaris 10 with OpenSSL

2008-09-10 Thread Randal T. Rioux
On Wed, September 10, 2008 10:54 am, Zdenek Kotala wrote: >>> Three questions (yeah, you forbided ask, but ...) >> >> grumble grumble grumble... >> >>> 1) Why 64 >>> >>> 64bit code on SPARC is slower, because SPARC uses 4byte instructions >>> and processing 64bit data needs more instructions. It is

Re: [GENERAL] What's size of your PostgreSQL Database?

2008-09-10 Thread Amber
Yes, we know both Greenplum and Netezza are PostgreSQL based MPP solutions, but they are commercial packages. I'd like to know are there open source ones, and I would suggest the PostgreSQL Team to start a MPP version of PostgreSQL. -- From: "Josh

Re: [GENERAL] FW: How to upload data to postgres

2008-09-10 Thread Markova, Nina
I also plan to try to export data in XML format (from Ingres) and import it to Postgres. I didn't find any utility for importing XML data into Postgres. Or just looking at the wrong document? I run Postgres 8.2.4 Thanks, Nina -Original Message- From: Adrian Klaver [mailto:[EMAIL PROTEC

Re: [GENERAL] What's size of your PostgreSQL Database?

2008-09-10 Thread Joshua Drake
On Wed, 10 Sep 2008 23:17:40 +0800 "Amber" <[EMAIL PROTECTED]> wrote: > > 1. Some kind of MPP. > 2. No single point of failure. > 3. Convenient and multiple access interfaces. > > And following the is the solutions we have examined: http://www.greenplum.com/ Joshua D. Drake -- The PostgreSQL

Re: [GENERAL] What's size of your PostgreSQL Database?

2008-09-10 Thread Amber
> Yahoo has a 2PB Postgres single instance Postgres database (modified > engine), but the biggest pure Pg single instance I've heard of is 4TB. > The 4TB database has the additional interesting property in that they've > done none of the standard "scalable" architecture changes (such as > partition

Re: [GENERAL] What's size of your PostgreSQL Database?

2008-09-10 Thread Amber
> 8. We have a master and a replica. We have plans to move to a > cluster/grid Soon(TM). It's not an emergency and Postgres can easily > handle and scale to a 3TB database on reasonable hardware (<$30k). > I'd like to know what's your progress of choosing the cluster/grid solution, we are also

Re: [GENERAL] plpgsql return select from multiple tables

2008-09-10 Thread Alvaro Herrera
Artis Caune escribió: > Ops, forget to mention that this function is not so simple and use > some plpgsql features. Ah, right, you only forgot to mention that other 99% of the requirements. What's wrong with your first example? -- Alvaro Herrerahttp://www.Comman

Re: [GENERAL] 64-bit Compile Failure on Solaris 10 with OpenSSL

2008-09-10 Thread Zdenek Kotala
Randal T. Rioux napsal(a): On Tue, September 9, 2008 5:25 am, Zdenek Kotala wrote: Randal T. Rioux napsal(a): I've battled this for a while. I'm finally breaking down and asking for help. If you're answer to this is "why 64-bit" then don't answer. You wouldn't understand. Same if you say "why

Re: [GENERAL] Autocommit, isolation level, and vacuum behavior

2008-09-10 Thread Jack Orenstein
Martijn van Oosterhout wrote: On Wed, Sep 10, 2008 at 09:45:04AM -0400, Jack Orenstein wrote: Am I on the right track -- does autocommit = false for the BIG scan force versions of TINY to accumulate? I played around with a JDBC test program, and so far cannot see how the autocommit mode causes

Re: [GENERAL] plpgsql return select from multiple tables

2008-09-10 Thread Filip Rembiałkowski
2008/9/10 Artis Caune <[EMAIL PROTECTED]>: > Hi, > > What is the correct way of writing plpgsql function which needs return > columns from multiple tables? > > e.x.: > SELECT email FROM emails WHERE id = 1 > SELECT backend FROM backends WHERE id = 1 > > I need plpgsql function return both email and

Re: [GENERAL] FW: How to upload data to postgres

2008-09-10 Thread Adrian Klaver
On Wednesday 10 September 2008 7:14:50 am Markova, Nina wrote: > Thanks Adrian. > > I have read the Postgres 'copy' - the problem is that Postgres doesn't > understand Ingres format. This is I think where the failure comes from. > If I don't find a tool, I have to write scripts to convert data to >

Re: [GENERAL] plpgsql return select from multiple tables

2008-09-10 Thread Artis Caune
On Wed, Sep 10, 2008 at 5:26 PM, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > Hmm, maybe > > select email, backend from emails, backends where email.id = 1 and > backend.id = 1; > ? > > You don't need a plpgsql function for this ... Ops, forget to mention that this function is not so simple and use

Re: [GENERAL] plpgsql return select from multiple tables

2008-09-10 Thread Alvaro Herrera
Artis Caune escribió: > Hi, > > What is the correct way of writing plpgsql function which needs return > columns from multiple tables? > > e.x.: > SELECT email FROM emails WHERE id = 1 > SELECT backend FROM backends WHERE id = 1 > > I need plpgsql function return both email and backend in one li

Re: [GENERAL] You need to rebuild PostgreSQL using --with-libxml.

2008-09-10 Thread Filip Rembiałkowski
2008/9/10 Ricardo Antonio Yepez Jimenez <[EMAIL PROTECTED]>: > > > Hi, > > As I compile postgresql 8.3.2 to support sql / xml, Red hat 5.1 enterprise > edition, I need to know the steps to comfigurarlo, if someone owns a manual. nothing fancy; just install libxml2 (on Debian I needed libxml2-dev,

Re: [GENERAL] Autocommit, isolation level, and vacuum behavior

2008-09-10 Thread Alvaro Herrera
Martijn van Oosterhout wrote: > Vacuum can only clean up stuff older than the oldest open transaction. > So if you have a transaction which is open for hours then stuff made > since then it can't be vacuumed. The solution is: don't do that. Actually it's worse than that: older than the oldest tra

[GENERAL] plpgsql return select from multiple tables

2008-09-10 Thread Artis Caune
Hi, What is the correct way of writing plpgsql function which needs return columns from multiple tables? e.x.: SELECT email FROM emails WHERE id = 1 SELECT backend FROM backends WHERE id = 1 I need plpgsql function return both email and backend in one line, like: SELECT email, backend FROM ...

Re: [GENERAL] FW: How to upload data to postgres

2008-09-10 Thread Markova, Nina
Thanks Adrian. I have read the Postgres 'copy' - the problem is that Postgres doesn't understand Ingres format. This is I think where the failure comes from. If I don't find a tool, I have to write scripts to convert data to something postgres understand. In the Ingres file with data for each v

Re: [GENERAL] PostgreSQL TPC-H test result?

2008-09-10 Thread Andrew Sullivan
On Tue, Sep 09, 2008 at 05:42:50PM -0400, Greg Smith wrote: > > While some of the MonetDB bashing in this thread was unwarranted, What bashing? I didn't see any bashing of them. A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-gene

Re: [GENERAL] Autocommit, isolation level, and vacuum behavior

2008-09-10 Thread Martijn van Oosterhout
On Wed, Sep 10, 2008 at 09:45:04AM -0400, Jack Orenstein wrote: > Am I on the right track -- does autocommit = false for the BIG scan force > versions of TINY to accumulate? I played around with a JDBC test program, > and so far cannot see how the autocommit mode causes variations in what is > s

[GENERAL] Autocommit, isolation level, and vacuum behavior

2008-09-10 Thread Jack Orenstein
I'm trying to understand the effect of autocommit on vacuum behavior (postgres 8.3, if it matters). Let's suppose you have two tables, BIG and TINY in a database accessed through JDBC. BIG has lots of rows. There are inserts, updates, and every so often there is a scan of the entire table. The

[GENERAL] You need to rebuild PostgreSQL using --with-libxml.

2008-09-10 Thread Ricardo Antonio Yepez Jimenez
Hi, As I compile postgresql 8.3.2 to support sql / xml, Red hat 5.1 enterprise edition, I need to know the steps to comfigurarlo, if someone owns a manual. Thank you. .

Re: [GENERAL] Server installation problem using freebsd ports

2008-09-10 Thread Bill Moran
In response to "Artis Caune" <[EMAIL PROTECTED]>: > On Tue, Sep 9, 2008 at 9:21 AM, Mohd Fahadullah <[EMAIL PROTECTED]> wrote: > > Hi, > > > > This might be a very small problem but I am stuck. When I try to install > > postgresql server 8.3.3 on freebsd using ports, I am getting - > > "postgresq

Re: [GENERAL] "Stuck" query

2008-09-10 Thread Tommy Gildseth
Tom Lane wrote: Tommy Gildseth <[EMAIL PROTECTED]> writes: Richard Huxton wrote: Looks like part of your query results being sent. Is it hung in that one system-call? Yes, I left it there for about ~1 hour, and that was all that ever came. Seems like you have got a network issue. What doe

Re: [GENERAL] psql scripting tutorials

2008-09-10 Thread John DeSoi
On Sep 10, 2008, at 2:46 AM, Artacus wrote: Who else is doing something like this? Can psql access environmental variables or command line params? Or do I have to have my bash script write a psql script every time? The psql \! command can execute shell commands. You can also use ``, e.g

Re: [GENERAL] "Stuck" query

2008-09-10 Thread Tom Lane
Tommy Gildseth <[EMAIL PROTECTED]> writes: > Richard Huxton wrote: >> Looks like part of your query results being sent. Is it hung in that one >> system-call? > Yes, I left it there for about ~1 hour, and that was all that ever came. Seems like you have got a network issue. What does netstat sho

Re: [GENERAL] ms windows: 40% space taken double by ../pg_tblspc folder?

2008-09-10 Thread Magnus Hagander
Willy-Bas Loos wrote: > Hi, > > Tablespaces are implemented as some sort of a hard link on windows, so > that the data seem to be in the program files, but they're not. No, they are implemented using softlinks, AKA NTFS Junctions. > When i look at my C drive with spacemonger though, it tells me

Re: [GENERAL] "Stuck" query

2008-09-10 Thread Tommy Gildseth
Richard Huxton wrote: Tommy Gildseth wrote: SELECT pg_cancel_backend(17504) has no effect, neither does kill 17504 from the shell. Strange. I tried "strace -p17504", and this gave me just the following output: sendto(7, "\7\0\0\0\003771\0\0\0\00224\0\0\0\017127.120.213.18"..., 968, 0, NULL,

[GENERAL] ms windows: 40% space taken double by ../pg_tblspc folder?

2008-09-10 Thread Willy-Bas Loos
Hi, Tablespaces are implemented as some sort of a hard link on windows, so that the data seem to be in the program files, but they're not. When i look at my C drive with spacemonger though, it tells me that the data in the tablespace IS in the program files folder - it is "fooled" by the hard link

[GENERAL] pg_start_backup() takes too long

2008-09-10 Thread Ivan Zolotukhin
Hello, What is the reason for select pg_start_backup('label'); taking 10 minutes on not so loaded system even right after manual checkpoint? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-gene

[GENERAL] "Stuck" query

2008-09-10 Thread Tommy Gildseth
I have a query on a database that has been running for nearly 24 hours at the moment. The query itself doesn't seem like it should take very long to run, so it seems like there's something else going on here. The output from pg_stat_activity looks like this: SELECT procpid, waiting, current_que

Re: [GENERAL] PostgreSQL TPC-H test result?

2008-09-10 Thread Simon Riggs
On Tue, 2008-09-09 at 16:26 -0400, Tom Lane wrote: > That's probably not good because it *looks* like we support the syntax, > but in fact produce non-spec-compliant results. I think it might be > better if we threw an error. Definitely. If we accept SQL Standard syntax like this but then not d

Re: [GENERAL] Various intermittent bugs/instability - how to debug?

2008-09-10 Thread Mark Cave-Ayland
Frederik Ramm wrote: Dear PostgreSQL community, I hope you can help me with a problem I'm having - I'm stuck and don't know how to debug this further. I have a rather large nightly process that imports a lot of data from the OpenStreetMap project into a PostGIS database, then proceeds d