On Apr 7, 2008, at 1:32 AM, David Wilson wrote:
I have a reasonably large table (~75m rows,~18gb) called vals. It
includes an integer datestamp column with approximately 4000 unique
entries across the rows; there is a normal btree index on the
datestamp column. When I attempt something like
Naz Gassiep wrote:
As you can see, they all are the same table, just repeatedly joined with
aliases.
Sorry, I'm obviously blind.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Hi,
I don't know if here is the right place to post this, but anyway ...
Does anybody know if there is any binary dist for win32 edb-debugger for
pgsql8.3?
If not, do you know which compiler I have to use?
I don't need to install anything on the client side where is my pgadmin,
right?
thx
Jeff Wigal wrote:
I am running Postgres 8.2.3 and am seeing the following error messages in my
logs:
LOG: SSL SYSCALL error: Connection reset by peer
LOG: could not receive data from client: Connection reset by peer
LOG: unexpected EOF on client connection
LOG: could not send data to
On Mon, Apr 7, 2008 at 2:05 AM, Alban Hertroys
[EMAIL PROTECTED] wrote:
On Apr 7, 2008, at 1:32 AM, David Wilson wrote:
The databases estimates seem consistent with yours, so why is it doing
this? Could you provide an EXPLAIN ANALYSE? It shows the actual numbers next
to the estimates,
On Mon, Apr 7, 2008 at 8:11 AM, josep porres [EMAIL PROTECTED] wrote:
Hi,
I don't know if here is the right place to post this, but anyway ...
Does anybody know if there is any binary dist for win32 edb-debugger for
pgsql8.3?
If not, do you know which compiler I have to use?
I don't need
Pavan Deolasee wrote:
On Fri, Apr 4, 2008 at 11:10 AM, Tom Lane [EMAIL PROTECTED] wrote:
The
policy of this project is that we only put nontrivial bug fixes into
back branches, and I don't think this item qualifies ...
Got it. I will submit a patch for HEAD.
Thanks,
As I
ok, thx,
I can debug from server pgadmin which ships with pg8.3 (1.8.2 rev 7030),
because it runs on windows,
but in the client side, running pgadmin1.8.2 rev 7050 it seems to hang, it
freezes.
Do I need to config anything?
thx
Josep Porres
2008/4/7, Dave Page [EMAIL PROTECTED]:
On Mon, Apr
On Mon, Apr 7, 2008 at 9:29 AM, josep porres [EMAIL PROTECTED] wrote:
ok, thx,
I can debug from server pgadmin which ships with pg8.3 (1.8.2 rev 7030),
because it runs on windows,
but in the client side, running pgadmin1.8.2 rev 7050 it seems to hang, it
freezes.
Do I need to config
I downloaded it from:
http://www.postgresql.org/ftp/pgadmin3/release/v1.8.2/win32/
spaninsh http mirror
http://wwwmaster.postgresql.org/download/mirrors-ftp?file=%2Fpgadmin3%2Frelease%2Fv1.8.2%2Fwin32%2Fpgadmin3-1.8.2-2.zip
Is this version wrong?
Josep Porres
2008/4/7, Dave Page [EMAIL
well, when you asked me about where I downloaded it, I downloaded it from I
installed it again.
It seems I can debug with no problems till now.
However, when I begin to debug and the function parameters window appears,
if I click cancel it freezes.
the log says:
2008-04-07 11:05:05 STATUS :
You should probably send those logs to the list, rather than straight to
me.
However, this line sticks out at me:
2008-04-07 07:43:14 GMT FATAL: lock file postmaster.pid already exists
2008-04-07 07:43:14 GMT HINT: Is another postmaster (PID 3724) running
in data directory F:/B?
Is it
On Mon, Apr 7, 2008 at 9:40 AM, josep porres [EMAIL PROTECTED] wrote:
I downloaded it from:
http://www.postgresql.org/ftp/pgadmin3/release/v1.8.2/win32/
spaninsh http mirror
http://wwwmaster.postgresql.org/download/mirrors-ftp?file=%2Fpgadmin3%2Frelease%2Fv1.8.2%2Fwin32%2Fpgadmin3-1.8.2-2.zip
On Mon, Apr 7, 2008 at 10:21 AM, josep porres [EMAIL PROTECTED] wrote:
well, when you asked me about where I downloaded it, I downloaded it from I
installed it again.
It seems I can debug with no problems till now.
However, when I begin to debug and the function parameters window appears,
if
On Saturday 05 April 2008 11:21, Tom Lane wrote:
Scott Marlowe [EMAIL PROTECTED] writes:
what type is new.ontime ?? timestamp or interval. I would expect it
to be an interval. But intervals are either negative or positive, not
ago unless that's something peculiar to 7.4 that I've long
if I try to close the parameter window using X button instead of Cancel,
it's the same.
It's a bit annoying when I finnish debugging, but I can debug, so it's fine
:)
I will be looking forward new versions.
thanks again Dave
Josep Porres
2008/4/7, Dave Page [EMAIL PROTECTED]:
On Mon, Apr 7,
pgAgent works well for me and it is built into pgAdmin.
http://www.pgadmin.org/docs/1.8/pgagent.html
Jon
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Tim Uckun
Sent: Sunday, April 06, 2008 11:10 PM
To:
On Sat, Apr 05, 2008 at 08:42:34PM -0700, Frank Miles wrote:
Unfortunately this does not help for lesser events (i.e. NOTICE and WARNING).
My preliminary effort suggests that psycopg isn't passing these.
Not as exceptions, certainly.
For one thing there's
cursor.statusmessage which (should)
On Apr 6, 1:34 pm, [EMAIL PROTECTED] (Craig Ringer) wrote:
Kev wrote:
So I tried to do this in Perl, but for some reason neither
kill() nor Win32::Process::KillProcess() actually terminate the
threads.
Threads? Each backend is a distinct process. I haven't the foggiest why
they might be
On Apr 5, 6:36 pm, [EMAIL PROTECTED] (Douglas McNaught) wrote:
On Thu, Apr 3, 2008 at 2:34 PM, Dan99 [EMAIL PROTECTED] wrote:
Hi,
I am having some troubles with a select group of tables in a database
which are acting unacceptably slow. For example a table with
approximately 10,000
I'm trying to upgrade to perl 5.10, and realized that plperlu is still
using 5.8. How exactly does pgsql determine where to look/what
version to use for plperlu?
Thanks,
Kev
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Kev [EMAIL PROTECTED] writes:
I'm trying to upgrade to perl 5.10, and realized that plperlu is still
using 5.8. How exactly does pgsql determine where to look/what
version to use for plperlu?
You need to recompile. You also need a pretty darn recent release of PG
(we only fixed things for
On Mon, Apr 7, 2008 at 9:51 AM, Dan99 [EMAIL PROTECTED] wrote:
Unfortunately, I did not design this database (or the website for that
matter) and am only maintaining it. As a result of the inexperience
of the website designer, there are no indexes in any of the tables and
it would be
On Monday 07 April 2008, Dan99 [EMAIL PROTECTED] wrote:
Does TRUNCATE TABLE keep all necessary table
information such as indexes, constraints, triggers, rules, and
privileges?
Yes. It does require an exclusive lock on the table very briefly, though,
which DELETE does not.
Currently a mass
josep porres wrote:
Hi,
I don't know if here is the right place to post this, but anyway ...
Does anybody know if there is any binary dist for win32 edb-debugger
for pgsql8.3?
If not, do you know which compiler I have to use?
I don't need to install anything on the client side where is my
josep porres wrote:
2008/4/7, Dave Page [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]:
On Mon, Apr 7, 2008 at 10:21 AM, josep porres [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] wrote:
well, when you asked me about where I downloaded it, I
downloaded it from I
installed it
It appears the errors were caused by table corruption. I've
truncated and reloaded some large table (300m entries),
and the problem disappeared. Table corruption was probably
caused by hardware failure, not by PostgreSQL :)
On Fri, 2008-04-04 at 20:15 -0400, Tom Lane wrote:
Alex Vinogradovs
On Mon, 07 Apr 2008 10:26:23 -0500
Tony Caduto [EMAIL PROTECTED] wrote:
You can use the Lightning Admin win32 debugger, very stable and FREE.
The edb-debugger is open source??? Or are you just saying that although
the Lightning Admin debugger is not open source it is FREE? (which is
fine of
Joshua D. Drake wrote:
On Mon, 07 Apr 2008 10:26:23 -0500
Tony Caduto [EMAIL PROTECTED] wrote:
You can use the Lightning Admin win32 debugger, very stable and FREE.
The edb-debugger is open source??? Or are you just saying that although
the Lightning Admin debugger is not open source it is
On Mon, 07 Apr 2008 19:07:22 +0200
Magnus Hagander [EMAIL PROTECTED] wrote:
Yes. The edb debugger is open source (it's on pgfoundry), and the LA
debugger client is free-as-in-beer. You know, kinda like PostgreSQL
vs Oracle Express ;)
Uhmm Oracle Express is crippleware. I don't think Tony's
Joshua D. Drake wrote:
On Mon, 07 Apr 2008 19:07:22 +0200
Magnus Hagander [EMAIL PROTECTED] wrote:
Yes. The edb debugger is open source (it's on pgfoundry), and the
LA debugger client is free-as-in-beer. You know, kinda like
PostgreSQL vs Oracle Express ;)
Uhmm Oracle Express is
Magnus Hagander wrote:
You know, kinda like PostgreSQL vs Oracle Express ;)
Well, not quite the same since LA Debugger Client is not crippled in
some way Like Oracle or MS SQL Express :-)
It's just plain old freeware.
Later,
Tony
--
Sent via pgsql-general mailing list
On Apr 7, 2008, at 9:47 AM, David Wilson wrote:
On Mon, Apr 7, 2008 at 2:05 AM, Alban Hertroys
[EMAIL PROTECTED] wrote:
The databases estimates seem consistent with yours, so why is it
doing
this? Could you provide an EXPLAIN ANALYSE? It shows the actual
numbers next
to the estimates,
On Mon, 7 Apr 2008 19:42:02 +0200
Alban Hertroys [EMAIL PROTECTED] wrote:
explain analyze select distinct datestamp from vals;
QUERY
PLAN
--
In porting from 7.4.19 to 8.3.1 I have found the following:
7.4.19:
mwr=# select interval '1 day 15 hours 30 minutes' - interval '29 hours';
?column?
@ 10 hours 30 mins
(1 row)
8.3.1:
mwr83=# select interval '1 day 15 hours 30 minutes' - interval '29 hours';
On Mon, Apr 7, 2008 at 1:42 PM, Alban Hertroys
[EMAIL PROTECTED] wrote:
Have you tried this query with enable_seqscan=off? If my guess is right
(and the planners, in that case) it'd be even slower.
set enable_seqscan=off;
explain select distinct datestamp from vals;
Terry Lee Tucker wrote:
In porting from 7.4.19 to 8.3.1 I have found the following:
7.4.19:
mwr=# select interval '1 day 15 hours 30 minutes' - interval '29 hours';
?column?
@ 10 hours 30 mins
(1 row)
8.3.1:
mwr83=# select interval '1 day 15 hours 30
Hi there,
I need some help. We have a Web application connecting to a postgresql
8.2 database on Windows Server 2003. According to the log, we logged on
the server using a remote control desktop, after uninstalling Tomcat we
installed a new Tomcat version. After that, we shutted down the
test
--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
--
Sent via
thanks Tony,
I'm going to take a look to it tomorrow morning.
Josep Porres
2008/4/7, Tony Caduto [EMAIL PROTECTED]:
josep porres wrote:
2008/4/7, Dave Page [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]:
On Mon, Apr 7, 2008 at 10:21 AM, josep porres [EMAIL PROTECTED]
mailto:[EMAIL
On Mon, 7 Apr 2008 10:47:58 -0700
Joshua D. Drake [EMAIL PROTECTED] wrote:
http://www.postgresql.org/mailpref/pgus-general
Sorry for the confusion folks. The /community/lists link is currently
broken. It has just been fixed but will take a little bit to migrate to
the mirrors. Please use the
David Wilson [EMAIL PROTECTED] writes:
I appreciate the responses so far! I'm used to several minutes for
some of the complex queries on this DB, but 12.5 minutes for a select
distinct just seems wrong. :)
You could try changing it to the equivalent GROUP BY query. The planner,
unfortunately,
There is probably a really simple solution for this problem, but for the
life of me I can't see to think of it. I have three tables
--contains u/p for all users in the site
TABLE users (user_id INT primary key, username VARCHAR(50), password TEXT)
--list of all possible events (login, logout,
On Mon, Apr 7, 2008 at 7:57 PM, Gregory Stark [EMAIL PROTECTED] wrote:
You could try changing it to the equivalent GROUP BY query. The planner,
unfortunately, doesn't know they're equivalent and has two separate sets of
plans available. In this case where there are only 4,000 distinct
David Wilson escribió:
explain analyze select datestamp from vals group by datestamp;
QUERY
PLAN
Mike Ginsburg wrote:
There is probably a really simple solution for this problem, but
for the life of me I can't see to think of it. I have three tables
--contains u/p for all users in the site TABLE users (user_id INT
primary key, username VARCHAR(50), password TEXT) --list of all
possible
Still doing the sequential scan on the table, but at least it's
avoiding the expensive disk merge sort. It still seems as if I ought
to be able to coax it into using an index for this type of query,
though- especially since it's using one on the other table. Is there
perhaps some way to
We have a PostgreSQL 8.2.6 installation running for about six-months
now. There was a lot of log entries saying (sometimes 10 or more in
just one second):
WARNING: oldest xmin is far in the past
HINT: Close open transactions soon to avoid wraparound problems.
(actually it was in Spanish but I
Manuel Sugawara wrote:
Hi Manuel,
The funny thing is that there was no open transactions, even after
restarting the cluster the same message was logged. Today, the
database stopped working as expected:
ERROR: database is shut down to avoid wraparound data loss in database
postgres
HINT:
Hi!
I am in the process of migrating a PostgreSQL 8.2.4 database to 8.3. So far,
everything has worked fine, even tsearch2-searching an indexed table.
There's something severely wrong with the trigger-function I use to keep the
tsvector-column updated.
Here's my table definition:
CREATE
David Wilson [EMAIL PROTECTED] writes:
It appears to be doing a sequential scan regardless of the set, as if
it doesn't believe it can use the index for some reason
More likely, it's getting a cost estimate for the indexscan that's so
bad that it even exceeds the 1-unit thumb on the
Tom Lane escribió:
What I think you'll find, though, is that once you do force an indexscan
to be picked it'll be slower. Full-table index scans are typically
worse than seqscan+sort, unintuitive though that may sound.
Hmm, should we switch the CLUSTER code to do that?
--
Alvaro Herrera
Alvaro Herrera [EMAIL PROTECTED] writes:
Tom Lane escribió:
What I think you'll find, though, is that once you do force an indexscan
to be picked it'll be slower. Full-table index scans are typically
worse than seqscan+sort, unintuitive though that may sound.
Hmm, should we switch the
Alvaro Herrera [EMAIL PROTECTED] writes:
Hi Manuel,
Hi Alvaro!
I suggest you look for temp tables that have not been reclaimed.
We've had a couple of reports where leftover temp tables have
stopped the frozen-xid counter from advancing. (They would have a
very old relfrozenxid.)
Thank
Alban Hertroys wrote
Something that might help you, but I'm not sure whether it
might hurt
the performance of other queries, is to cluster that table on
val_datestamp_idx. That way the records are already (mostly) sorted
on disk in the order of the datestamps, which seems to be the
Markus Wollny [EMAIL PROTECTED] writes:
Now when I do anything that fires the trigger like
UPDATE ct_com_board_message set count_reply = 1 where message_id = 12345;
I get an error
ERROR: column idxfti is not of tsvector type
This is leaping to conclusions, but what I suspect is that you've
Manuel Sugawara [EMAIL PROTECTED] writes:
Alvaro Herrera [EMAIL PROTECTED] writes:
Hi Manuel,
Hi Alvaro!
I suggest you look for temp tables that have not been reclaimed.
We've had a couple of reports where leftover temp tables have
stopped the frozen-xid counter from advancing. (They
Hi!
Tom Lane wrote:
This is leaping to conclusions, but what I suspect is that you've got
two types tsvector in your database and the column is the wrong
one.
This situation is not too hard to get into if you try to restore a
dump from an old database that used contrib/tsearch2 --- the dump
58 matches
Mail list logo