On Wed, 4 Jun 2008, Gurjeet Singh [EMAIL PROTECTED] writes:
If you search for OpenSSI Postgres, you hit this link:
http://wiki.openssi.org/go/PostgreSQL_on_OpenSSI_enabled_Knoppix
I have done this setup and small test on it about an year ago. The
performance was horrible. I cannot say for
On Wed, 2008-06-04 at 22:54 -0700, Richard Broersma wrote:
I just bought a new Ubuntu Laptop so that I could tryout and hopefully
offer support for a few of my favorite pgfoundry projects.
Would anyone be able to give any dirction on what I need to do to get
passed this error?
You don't
Richard Broersma [EMAIL PROTECTED] writes:
Would anyone be able to give any dirction on what I need to do to get
passed this error?
/usr/bin/ld: crt1.o: No such file: No such file or directory
Seems you've got an incomplete installation. On my Fedora machine,
crt1.o is provided by the
Is there a way to send additional arguments when defining a custom
aggregate?
I wrote a mysql style group_concat aggregate. You get DISTINCT for
free. I want to be able to define if it is sorted and what the
separator is.
Art
--
Sent via pgsql-general mailing list
On Wed, Jun 4, 2008 at 11:20 PM, Joshua D. Drake [EMAIL PROTECTED] wrote:
You don't have any build tools install. Try:
apt-get install binutils gcc autoconf flex
Thanks gentlemen, I will give these ideas a try.
--
Regards,
Richard Broersma Jr.
Visit the Los Angles PostgreSQL Users Group
3 jun 2008 kl. 23.31 skrev Joris Dobbelsteen:
Henrik wrote:
Hi list,
I'm having a table with a lots of file names in it. (Aprox 3
million) in a 8.3.1 db.
Doing this simple query shows that the statistics is way of but I
can get them right even when I raise the statistics to 1000.
db=#
3 jun 2008 kl. 16.06 skrev Scott Marlowe:
On Tue, Jun 3, 2008 at 7:41 AM, Henrik [EMAIL PROTECTED] wrote:
To be able to handle versions we always insert new folders even
though
nothing has changed but it seemd like the best way to do it.
E.g
First run:
tbl_file 500k new files.
Hi,
I tried to use pg_dump to restore (sync) a database, but I noticed that
the system table pg_namespace was not synced.
I tried the following pg_dump command to just restore that table without
success either.
Does pg_dump support for the system tables or something I missed ?
Is there
I have a query that takes 2.5 sec if I run it from a freshly restored
dump. If I run a full vacuum on the database it then takes 30 seconds.
Would someone please comment as to why I would see over a 10x slow down
by only vacuuming the DB?
I am using 8.3.1
--
Sent via pgsql-general mailing
I have a query that takes 2 sec if I run it from a freshly restored
dump. If I run a full vacuum on the database it then takes 30 seconds.
Would someone please comment as to why I would see a 15x slow down by
only vacuuming the DB?
I am using 8.3.1
--
Sent via pgsql-general mailing list
Le jeudi 05 juin 2008, Joshua D. Drake a écrit :
You don't have any build tools install. Try:
apt-get install binutils gcc autoconf flex
Or even better:
apt-get build-dep postgresql-8.3
--
dim
signature.asc
Description: This is a digitally signed message part.
Tom Lane wrote:
Richard Broersma [EMAIL PROTECTED] writes:
Would anyone be able to give any dirction on what I need to do to get
passed this error?
/usr/bin/ld: crt1.o: No such file: No such file or directory
Seems you've got an incomplete installation. On my Fedora machine,
crt1.o is
On 05/06/2008 10:52, Bjørn T Johansen wrote:
If I already have a running database, how can I compare the tables in
the database with the sql script to discover the differences?
You can use pg_dump with the -s option to dump the schema of the
database, and run it through the diff tool of your
If I already have a running database, how can I compare the tables in the
database with the sql script to discover the differences?
Regards,
BTJ
--
---
Bjørn T Johansen
[EMAIL PROTECTED]
On Thu, 05 Jun 2008 11:06:36 +0100
Raymond O'Donnell [EMAIL PROTECTED] wrote:
On 05/06/2008 10:52, Bjørn T Johansen wrote:
If I already have a running database, how can I compare the tables in
the database with the sql script to discover the differences?
You can use pg_dump with the -s
Gary Fu wrote:
I tried to use pg_dump to restore (sync) a database, but I noticed that
the system table pg_namespace was not synced.
If you restore a database, entries in pg_namespace will be created if
the dump contains any CREATE SCHEMA statements, i.e. if there are
schemas in your original
On Thu, Jun 5, 2008 at 2:15 AM, Craig Ringer
[EMAIL PROTECTED] wrote:
sudo apt-get build-dep postgresql
Thanks, this works perfectly now!
--
Regards,
Richard Broersma Jr.
Visit the Los Angles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-general mailing
Apart from concurrency issues, it is possible that you
have sequence generation problems. Depending on how
you inserted the original rows into the 'purchases' table, it is possible
that the nextval number has not kept-up and is lagging behind.
You need to ensure that
Hi,
Bjørn T Johansen wrote:
On Thu, 05 Jun 2008 11:06:36 +0100
Raymond O'Donnell [EMAIL PROTECTED] wrote:
On 05/06/2008 10:52, Bjørn T Johansen wrote:
If I already have a running database, how can I compare the tables in
the database with the sql script to discover the differences?
You can
In-Reply-To: : [EMAIL PROTECTED]
On: Thu, 05 Jun 2008 09:03:14 +0300, Volkan YAZICI [EMAIL PROTECTED] wrote:
BTW, can you comment on the activity of the OpenSSI project. A project
with a dead main page (see http://openssi.org) doesn't smell good to
me. Are there any alive support in the
On Thu, 5 Jun 2008, James B. Byrne [EMAIL PROTECTED] writes:
The link http://openssi.org redirects to
http://openssi.org/cgi-bin/view?page=openssi.html and the most recent
(pre-)release is discussed here:
http://sourceforge.net/forum/forum.php?forum_id=768341
Hrm... It didn't 3-4 days ago.
Hi all - I am wondering if I can get a consensus on what to do about
this minor issue. I have looked through the archives and can't find a
definitive answer.
So I have a new 8.1 install on Linux (have not yet been able to
upgrade to 8.3). The documentation say that autovacuum is enabled by
On Thu, 05 Jun 2008 15:28:55 +0200
Tino Wildenhain [EMAIL PROTECTED] wrote:
Hi,
Bjørn T Johansen wrote:
On Thu, 05 Jun 2008 11:06:36 +0100
Raymond O'Donnell [EMAIL PROTECTED] wrote:
On 05/06/2008 10:52, Bjørn T Johansen wrote:
If I already have a running database, how can I compare
Hi all
I assume this is not an uncommon problem, but so far, I haven't been
able to find a good answer to it.
I've got a table that holds log entries and fills up very fast during
the day, it gets approx. 25 million rows per day. I'm now building a web
application using apache/mod_php where
In response to Tim Tassonis [EMAIL PROTECTED]:
Hi all
I assume this is not an uncommon problem, but so far, I haven't been
able to find a good answer to it.
I've got a table that holds log entries and fills up very fast during
the day, it gets approx. 25 million rows per day. I'm now
Hi,
Tim Tassonis wrote:
Hi all
I assume this is not an uncommon problem, but so far, I haven't been
able to find a good answer to it.
I've got a table that holds log entries and fills up very fast during
the day, it gets approx. 25 million rows per day. I'm now building a web
application
In response to Tim Tassonis [EMAIL PROTECTED]:
Bill Moran wrote:
In response to Tim Tassonis [EMAIL PROTECTED]:
Now, with apache/php in a mpm environment, I have no guarantee that a
user will get the same postgresql session for a subsequent request, thus
he will not see the
At work I am creating a standard postgresql benchmark suite based on the
queries and operations that we commonly do.
A couple of questions
+ Should I shutdown/restart the DB between runs?
+ How much bigger than memory should my tables be to have a good benchmark?
One issue to keep in mind is
Don't see any activity in the project since 2006. Is that project dead?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I'm using some simple migration code to execute individual fragments of
SQL code based on the version of the schema. Is there a way to perform
an ALTER TABLE conditionally?
Example:
I want to add column foo to table bar, but only if column foo does not
exist already.
I'm trying to avoid
Tino Wildenhain wrote:
Hi,
Tim Tassonis wrote:
Hi all
I assume this is not an uncommon problem, but so far, I haven't been
able to find a good answer to it.
I've got a table that holds log entries and fills up very fast during
the day, it gets approx. 25 million rows per day. I'm now
I have a table of organizations that has a many-to-many relationship
with itself via another table called relationships. The relationships
table has a serial id primary key and parent_id and child_id integer
fields. The organizations table has a couple thousand records and the
maximum depth is
On Thu, 2008-06-05 at 14:10 -0400, Francisco Reyes wrote:
Don't see any activity in the project since 2006. Is that project dead?
I think greenplum would be a better place to ask but from what I can
tell, its dead.
Joshua D. Drake
--
Sent via pgsql-general mailing list
On Thu, Jun 5, 2008 at 5:36 PM, Tim Tassonis [EMAIL PROTECTED] wrote:
Is there a way to create temporary tables in another way, so they are
visible between sessions, or do I need to create real tables for my purpose?
And is the perfomance penalty big for real tables, as they have been written
Can't you just try to add the column and catch the error? If you're
in a transaction use a user defined function to run it an catch the
exception in pl/pgsql.
On Thu, Jun 5, 2008 at 12:15 PM, Michael P. Soulier
[EMAIL PROTECTED] wrote:
I'm using some simple migration code to execute individual
Tom Lane escribió:
A B [EMAIL PROTECTED] writes:
Whenever I use copy-paste to run code in a terminal window that is
running psql, and the code contains a row like
[...]
Either avoid copying/pasting tabs, or turn off readline
(-n option to psql, I think, but check the manual).
There's
Have you run analyze on the tables? bumped up default stats and re-run analyze?
Best way to send query plans is as attachments btw.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Oh, another point of attack. Always test your queries under just
\timing. You can wrap up like this:
\timing
select count(*) from (subselect goes here);
I've been on a few machines where the cost of explain analyze itself
threw the timing way off.
--
Sent via pgsql-general mailing list
is there a tentative release date (week ... month) for postgres-8.3.2 ?
Thanks!
Vlad
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Thanks for the advice. I will keep playing with it. Can someone here
comment on EnterpriseDB or another companies paid support? I may
consider this to quickly improve my performance.
Scott Marlowe wrote:
Have you run analyze on the tables? bumped up default stats and re-run analyze?
Best
Hi all,
I have a problem connecting to postgres via the python pg module ONLY
from the cgi-scripts.
The command is:
db=pg.connect('aqdev','localhost',5432,None,None,'postgres',None)
From the commandline the connection works great, but from a cgi-script
it barfs with the following
Just solved it.
For others, here is the solution.
setsebool -P httpd_can_network_connect_db 1
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dan Joo
Sent: Thursday, June 05, 2008 4:18 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] postgres connection problem
Dan Joo wrote:
db=pg.connect('aqdev','localhost',5432,None,None,'postgres',None)
From the commandline the connection works great, but from a
cgi-script it barfs with the following message:
*InternalError*: could not create socket: Permission denied
My (obvious, granted) guess is that you're
Using postgresql 8.3 on windows 2003 server. I keep seeing this message in
my system log. Checking the times, it seems to coincide with a log
rollover each time, almost as though the db were trying to log something at
precisely the same time as it is closing access to the old file, and before
On Tue, May 27, 2008 at 9:24 AM, A B [EMAIL PROTECTED] wrote:
Whenever I use copy-paste to run code in a terminal window that is
running psql, and the code contains a row like
IF FOUND THEN
then I get the words
ABORTCHECKPOINT COMMIT DECLARE EXECUTE
[...]
As others
I understand from
http://www.postgresql.org/docs/8.0/static/datatype-money.html that the
money data type is deprecated.
So I want to convert the data from my existing money columns into new
un-deprecated columns, e.g. with type decimal(10,2). But every SQL
command I try tells me I can't
Ken Winter wrote:
I understand from
http://www.postgresql.org/docs/8.0/static/datatype-money.html that the
“money” data type is deprecated.
Money is no longer deprecated in newer releases (specifically 8.3),
although I do think it would be wise to push it to numeric.
I think the way to do
On Fri, Jun 6, 2008 at 7:58 AM, Merlin Moncure [EMAIL PROTECTED] wrote:
On Tue, May 27, 2008 at 9:24 AM, A B [EMAIL PROTECTED] wrote:
Whenever I use copy-paste to run code in a terminal window that is
running psql, and the code contains a row like
IF FOUND THEN
then I get the words
Hi Tim,
Off the top of my head, from somewhat left field, using filesystems to manage
this sort of effect.
Would real tables in a tablespace defined on a ramdisk meet this need? So the
functionality/accessibility of a
physical table is provided, along with the performance of a filesystem
I have a table of organizations that has a many-to-many relationship
with itself via another table called relationships. The relationships
table has a serial id primary key and parent_id and child_id integer
fields. The organizations table has a couple thousand records and the
maximum depth is
Gary Fu wrote:
I tried to use pg_dump to restore (sync) a database, but I noticed that
the system table pg_namespace was not synced.
If you restore a database, entries in pg_namespace will be created if
the dump contains any CREATE SCHEMA statements, i.e. if there are
schemas in your
Gary Fu [EMAIL PROTECTED] writes:
My question now is why those temporary schemas won't be cleaned
after I restart the db ?
Just leave them alone and you'll be fine. These tools actually have
had most of the bugs worked out of them ;-) ... if you think pg_dump is
omitting something, you are
52 matches
Mail list logo