specifically with a qualified path ("status -p
/var/run/postmaster-9.1.pid"), even though line 70 specifies a variable to
point to the pid file (pidfile="/var/run/postmaster-9.1.pid").
This is with rpm version of postgres 9.1.4 and 9.1.6 (we haven't tested
9.1.7 at this
COPY promo_nonactive_load_fake, line 239900
Note that the error is wrong, the field is quoted but postgres seems to jump
forward in the file when it encounters the nul bytes.
Further, the line number is wrong. That is the length of the file (in
lines), not the line on which the error occurs, which is several hu
Why is cost_hashjoin estimating 50 billion tuple comparisons for 10K rows of
output though?
From: Tom Lane
To: postgresu...@yahoo.com
Cc: pgsql-bugs@postgresql.org
Sent: Wednesday, May 30, 2012 10:03 PM
Subject: Re: [BUGS] BUG #6668: hashjoin cost problem
The following bug has been logged on the website:
Bug reference: 6425
Logged by: orval
Email address: postg...@dunquino.com
PostgreSQL version: 9.0.6
Operating system: Solaris 10 u9
Description:
This is intermittent and hard to reproduce but crashes consistently in th
The following bug has been logged online:
Bug reference: 6252
Logged by: Can not create DB by 'createdb.exe' when DB 'postgres'
is droped
Email address: yanghui...@gmail.com
PostgreSQL version: 9.0.5
Operating system: Windows XP SP2
Description:Af
We have seen a strange situation with postgres 8.3.6 taking longer times for
inserting a fixed amount of data. The insertion time is increasing as the data
in the table is growing. We tried to use COPY command but to no avail. The
increase is also not linear. Insert is one of the basic
importnace. But now it seems more like the community not knowing what triggered
the issue i.e. not knowing which component to fix.
But I do have one overriding question - since postgres is still running on the
same hardware, wouldn't it ru
the use of Visual
Studio, the details can be read up here:
http://trolltech.com/developer/knowledgebase/faq.2006-12-05.8269192532/
Great thanks go to the Postgres team! You have really built an amazing
piece of software. I use it as my preferred database (custom compiled
on each box. On windows a
People,
Thanks for your help with my problem with NULL values. Also, particular
thanks for a hint on where to find a copy of SQL-92 standard, something
I didn't already have. It was annoying to discover that UNIQUE didn't
have what I felt was the "obvious" meaning, but it doesn't and PostgreSQL
I know this has been discussed many times before but I'm not entirely
satisfied with the answer, which I understand is "views are essentially
macros". Despite that Postgres is producing the correct output, I hope
you'll all agree that the performance issue is serious enough
Tom Lane <[EMAIL PROTECTED]> wrote:
> I assume though that this is a made-up example and is not the case
> that's really troubling you. What is the actual problem you are looking
> at?
I was generating random test data and naively assumed that ()::integer
truncated its value, therefore I was gett
11 matches
Mail list logo
