Is this running as one transaction, or is it not a transaction? Have you
tried committing every 10,000 or so if it is in one transaction? It could
be a logging problem with the transaction being too big.
Does the file system as a whole get slow, or just Postgres? Is it one
connection, or does
Left/Outer joins are supported, but not until version 7.1. Most Linux
distros are shipping still with 7.0.3. Upgrade. Your problem will be
fixed.
__
Your mouse has moved.
You must rest
2 questions:
1) Have you recently run an analyze?
2) Are you sure that an index scan would be more efficient than a seq
scan? (are less than 25% of the records selected) I don't know the
break-off boint in the query optimizer, but it may be more efficient on
that table to read the whole thing.
You could fake some of this (select only) by using the dblink stuff in
contrib. You could link back to yourself and make it work. Maybe if
you REALLY need it, you could modify dblink to allow updates as well as
selects. If you really need it that bad, you have the source, write it.
--
exec_cmd(conn, "END TRANSACTION");
exit(0);
}
void exec_cmd(PGconn *conn, char *str)
{
PGresult *res;
if ((res = PQexec(conn, str)) == NULL) {
fprintf(stderr, "Error executing %s.\n", str);
fprintf(stderr, "Error message: %s\n", PQerrorMessage(conn));
exit(1);
}
if (PQresultStatus(res) != PGRES_COMMAND_OK) {
fprintf(stderr, "Error executing %s.\n", str);
fprintf(stderr, "Error message: %s\n", PQerrorMessage(conn));
PQclear(res);
exit(1);
}
PQclear(res);
}
--
Ian Grant, Computer Lab., New Museums Site, Pembroke Street, Cambridge
Phone: +44 1223 334420 Personal e-mail: iang at pobox dot com
believed it was then fixed by Tatsuo, after a couple of iterations. I'm
sorry to be the bearer of bad news ...
Please reply to me directly since I'm not on the list.
Thanks
Ian
--
Ian Grant, Computer Lab., New Museums Site, Pembroke Street, Cambridge
Phone: +44 1223 334420 Personal e-mail: iang at pobox dot com
sage(conn));
exec_cmd(conn, "END TRANSACTION");
exit(0);
}
void exec_cmd(PGconn *conn, char *str)
{
PGresult *res;
if ((res = PQexec(conn, str)) == NULL) {
fprintf(stderr, "Error executing %s.\n", str);
fprintf(stderr, "Error message: %s\n", PQerrorMessage(conn));
exit(1);
}
if (PQresultStatus(res) != PGRES_COMMAND_OK) {
fprintf(stderr, "Error executing %s.\n", str);
fprintf(stderr, "Error message: %s\n", PQerrorMessage(conn));
PQclear(res);
exit(1);
}
PQclear(res);
}
--
Ian Grant, Computer Lab., New Museums Site, Pembroke Street, Cambridge
Phone: +44 1223 334420 Personal e-mail: iang at pobox dot com
our mind
you might consider implementing lo_truncate (the lo_ analog of the unix truncate
system call.) At present there is no way to reduce the size of a large object except
by copying to a new one (and then we still can't delete the old one, or can we do that
now?)
Cheers
Ian
--
Ian Gr
I have noticed that some of the command line tools do not work nicely
when the local auth is not set to trust, but trust is dangerous. Have
you tried creating the language from psql rather than from the command line?
[EMAIL PROTECTED] wrote:
>postgres@abigail ~/data $ createdb test1
>Password
All CYGWIN users, make sure that cygipc is on your machine and running before
doing anything with Postgres.
Michaele Holtman wrote:
[EMAIL PROTECTED]">
I am trying to use postgres with the CYGWIN
binaries for WIN/2000. I started initdb with '--debug' and it got as far
as
postgr
Hello PostgreSQL people,
Thanks for making PostgreSQL, it's great. Here's a bug report.
Thanks
Ian
Your name : Ian Grant
Your email address : [EMAIL PROTECTED]
System Configuration
-
Architecture (example: Intel Pentium) : ia64,
> Ian Grant <[EMAIL PROTECTED]> writes:
> > Architecture (example: Intel Pentium) : ia64, 4 way SMP
> > Operating System (example: Linux 2.0.26 ELF) : Linux 2.4.3 SMP kernel
>
> Does anything else work for you on that box? I seem to recall that
>
> Ian Grant <[EMAIL PROTECTED]> writes:
> > Architecture (example: Intel Pentium) : ia64, 4 way SMP
> > Operating System (example: Linux 2.0.26 ELF) : Linux 2.4.3 SMP kernel
>
> Does anything else work for you on that box? I seem to recall that
>
The canned readline check assumes that curses is already installed. If it
isn't then the readline check fails and configure reports that readline is not
available. The real problem though is that curses is not available.
--
Ian Grant, Computer Lab., William Gates Building, JJ Thomso
> Sorry for buggering you, I get the point :)
I think you mean 'bugging.' Buggering is something quite different.
---(end of broadcast)---
TIP 8: explain analyze is your friend
and output columns;
nevertheless, the loosening of the behaviour of "group by" doesn't seem
to sit with the restriction on "having". I also appreciate the need to
support "standard" sql - but in the absence of ambiguities, shouldn't
this expression "do wha
I get the same thing with 8.0.4, on Windows XP Professional.
~Mike
Bruce Momjian wrote:
> Todd wrote:
> >
> > The following bug has been logged online:
> >
> > Bug reference: 2000
> > Logged by: Todd
> > Email address: [EMAIL PROTECTED]
> > PostgreSQL version: 8.1 Beta 4
> > Op
The following bug has been logged online:
Bug reference: 5955
Logged by: Rob Grant
Email address: r...@occipital.com
PostgreSQL version: 9.0
Operating system: OS X
Description:One-click installer does not escape password
Details:
I provided the one-click installer
The following bug has been logged online:
Bug reference: 5781
Logged by: Grant Hutchins and Peter Jaros
Email address: gr...@pivotallabs.com
PostgreSQL version: 9.0.1
Operating system: Mac OS X 10.6.4
Description:unaccent() function should be marked IMMUTABLE
Details
19 matches
Mail list logo
