On Tue, Sep 9, 2008 at 11:17 PM, 小波 顾 [EMAIL PROTECTED] wrote:
That's it, we have 4 CPUs, each of which has 4 cores, that is we have 16
cores in total, but we have only 4 to 8 concurrent users, who regularly run
complex queries. That is we can't use all our CPU resources in such a
situation
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 probably write some bash scripts to pull csv files over then script
psql to do a
Markova, Nina wrote:
Hi again,
I need to load data from Ingres database to Postgres database. What's
the easiest way?
Thanks,
Nina
Easiest way would be to export to CSV and import using COPY. Slickest
way would be to use something like dblink.
--
Sent via pgsql-general mailing list
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 -
postgresql-server-8.3.3 cannot install: unknown PostgreSQL version: 83
I was
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
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 do
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,
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:
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.
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, 0
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
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 show for
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 ``,
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 does
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 -
postgresql-server-8.3.3
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.
.
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
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
seen
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
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
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 ...
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
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,
djust
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 line, like:
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
some
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
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 backend in
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
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
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 Herrera
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
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
partitioning,
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 Company
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
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:
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 good only if
you
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 +
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
--- 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 document?
I run
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 of
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
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;
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
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
---
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. It's a
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 is
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
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 probably write
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
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.
.
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 please
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,
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 table
[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 concurrent
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
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
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.
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
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 then
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? A
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,
This might be a
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 as
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).
Total
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
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,
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
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
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 stuff all
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
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
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
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
72 matches
Mail list logo