On Tue, Sep 19, 2006 at 02:15:03PM -0400, Jonathan Vanasco wrote:
> Hi,
>
> I'm hoping someone on this list can save me some unnecessary
> benchmarking today
> a)one table with everything in it
> pro:
> simple
> possible con:
> when i had something
Alvaro,I wonder if we could replace the elephant logo with a female elephant logo. That could work wonders ... among the elephant community at least. Are there many elephants among decision makers?
Asking google:http://www.google.de/search?q=teach%20an%20elephant%20to%20dance&ie=UTF-8&oe=UTF-8&hl
On Wed, Sep 20, 2006 at 04:12:16PM -0700, Jeff Davis wrote:
> In 8.2, which is currently still in production, they have added the
> feature where you can do things like:
>
> DROP SEQUENCE IF EXISTS mysequence;
> CREATE SEQUENCE mysequence;
>
> Which makes writing SQL scripts much easier. They al
On Wed, Sep 20, 2006 at 02:29:16PM -0700, Johan wrote:
> I encountered a strange problem while trying to solve a bug. I use a
> postgresql 8.x database and a jdbc driver from
> postgresql-8.1dev-400.jdbc3.jar. The following is happening
Any reason you're not using the latest, postgresql-8.1-407.jd
On 21/9/2006 9:39, "Alvaro Herrera" <[EMAIL PROTECTED]> wrote:
> I wonder if we could replace the elephant logo with a female elephant
> logo. That could work wonders ... among the elephant community at
> least. Are there many elephants among decision makers?
Aren't they all elephants?
Oh hang
On 20/9/2006 16:55, "Lukasz" <[EMAIL PROTECTED]> wrote:
>
> Shane Ambler napisal(a):
>> On 19/9/2006 22:41, "Lukasz" <[EMAIL PROTECTED]> wrote:
>>
>>> Hello,
>>>
>>> I would like to install a PostgreSQL. I know how to manage the database
>>> itself, creae databases, user, groups and so on. But
In the last exciting episode, [EMAIL PROTECTED] wrote:
> Hi,
> I am trying to find out how to CREATE a table while Slony-I replication is
> running (meaning without stopping Slony-I replication adding/creating new
> table
> into replication)
I think you have some extra characters in the script.
To all involved in this project,
I justed wanted to let you know how impressed and pleased I have been with
postgres over the past 5 years . The timeliness and quality of the releases
are always robust and stable. Every release has a very nice mix of admin,
performance, platform, and feature
Hi Gurkan,I just tried the same but didn't face a problem while doing so. You can try the same steps that I did:1. Made a exec_scr file for Slonik with execute script command (i.e attached with the email)
2. Made a test.sql file which has the create table just like the one you mentioned (i.e attac
On 9/21/06, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
I wonder if we could replace the elephant logo with a female elephant
logo. That could work wonders ... among the elephant community at
least. Are there many elephants among decision makers?
our elephant isn't female? that changes everyth
PostgreSQL doesn't have any booth babes? ;P
csn
> On 09/20/06 16:38, Philip Hallstrom wrote:
> [snip]
> > I think that description is false. At a certain point in the
> > management hierarchy, the only way anyone has the ability to
> > evaluate something is on the basis of
> >
> > - if ther
Hi,
I am trying to find out how to CREATE a table while Slony-I replication is
running (meaning without stopping Slony-I replication adding/creating new table
into replication)
I have tried to run this but wont work. please help. thanks.
add_table.sh
#!/bin/sh
/opt/E
Ron Johnson wrote:
> On 09/20/06 16:38, Philip Hallstrom wrote:
> [snip]
> > I think that description is false. At a certain point in the
> > management hierarchy, the only way anyone has the ability to
> > evaluate something is on the basis of
> >
> > - if there is someone they can sue.
> >
You should also consider using connection pooling inorder to attain better performance.
Regards
Talha Khan
On 9/20/06, Najib Abi Fadel <[EMAIL PROTECTED]> wrote:
I have a web application that is accessed by a large number of users. My application is written in PHP and uses postgres. Apache is
On Wed, 2006-09-20 at 00:46 -0700, Najib Abi Fadel wrote:
> I have a web application that is accessed by a large number of users.
> My application is written in PHP and uses postgres. Apache is our web
> server.
> The performance of my application drops down when a large numbers of
> users connec
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/20/06 16:38, Philip Hallstrom wrote:
[snip]
> I think that description is false. At a certain point in the
> management hierarchy, the only way anyone has the ability to
> evaluate something is on the basis of
>
> - if there is someone they
On Wed, 2006-09-20 at 14:18 -0700, stevethames wrote:
> I have a script that sets up my databases which I run whenever I change any
> of the functions. It has a number of things it does that are unnecessary
> and cause errors. I create some types, sequences, etc. The error messages
> are irritat
> I have a web application that is accessed by a large number of users.
> My application is written in PHP and uses postgres. Apache is our web
> server.
> The performance of my application drops down when a large numbers of users
> connects at the same time. I need to have a better response time
Hi,
I'm hoping someone on this list can save me some unnecessary
benchmarking today
I have the following table in my system
BIGSERIAL , INT , INT, VARCHAR(32)
There are currently 1M records , it will grow to be much much
bigger. It's used as a search/dispatch table, and gets t
I have a web application that is accessed by a large number of users. My application is written in PHP and uses postgres. Apache is our web server.The performance of my application drops down when a large numbers of users connects at the same time. I need to have a better response time ! That's w
Hi,
I encountered a strange problem while trying to solve a bug. I use a
postgresql 8.x database and a jdbc driver from
postgresql-8.1dev-400.jdbc3.jar. The following is happening
The table is created like
create table test (
field1 int8 not null,
field2 int8 not null);
if I do a
select fiel
I have a script that sets up my databases which I run whenever I change any
of the functions. It has a number of things it does that are unnecessary
and cause errors. I create some types, sequences, etc. The error messages
are irritating. I'd like to do something like this:
IF NOT EXISTS (SEL
Shane Ambler napisal(a):
> On 19/9/2006 22:41, "Lukasz" <[EMAIL PROTECTED]> wrote:
>
> > Hello,
> >
> > I would like to install a PostgreSQL. I know how to manage the database
> > itself, creae databases, user, groups and so on. But I don't know how
> > to allow other users, who are outside LAN to
I have a web application that is accessed by a large number of users. My application is written in PHP and uses postgres. Apache is our web server.The performance of my application drops down when a large numbers of users connects at the same time. I need to have a better response time ! That's w
Am 2006-09-18 10:23:21, schrieb Csaba Nagy:
> The point was that you will never ever be able to cover all the variants
> existing in the weirdest email clients... however hard you try. You
> missed Hungarian which is my native language for example ;-)
But such things can be added later...
My str
On Wed, Sep 20, 2006 at 10:10:56AM -0500, Tony Caduto wrote:
For a high level corp manager all they ever hear about is MS SQL Server,
Oracle and DB2, and the more it costs the more they think it is what
they need :-)
I think that description is false. At a certain point in the
management hiera
On Wed, 2006-09-20 at 17:29 -0400, Terry Lee Tucker wrote:
> Well, I was assuming that that the table wasn't being dropped and that was
> what was causing the error. I can see from your comments, that I was wrong on
> that asssumption. I can do this with and execute, but it's going to be a pain
Thanks for the reponse Jeff. See comments below.
On Wednesday 20 September 2006 05:09 pm, Jeff Davis <[EMAIL PROTECTED]> thus
communicated:
--> On Wed, 2006-09-20 at 16:51 -0400, Terry Lee Tucker wrote:
--> > Greetings:
--> >
--> > I have have a plpgsql function that creates a temporary table to
On Wed, 2006-09-20 at 16:51 -0400, Terry Lee Tucker wrote:
> Greetings:
>
> I have have a plpgsql function that creates a temporary table to facilitate
> some processing. Here is the code:
> CREATE TEMP TABLE tmp (code VARCHAR,
>booked INTEGER,
>
Greetings:
I have have a plpgsql function that creates a temporary table to facilitate
some processing. Here is the code:
CREATE TEMP TABLE tmp (code VARCHAR,
booked INTEGER,
availINTEGER,
c
On Wed, Sep 20, 2006 at 10:10:56AM -0500, Tony Caduto wrote:
> For a high level corp manager all they ever hear about is MS SQL Server,
> Oracle and DB2, and the more it costs the more they think it is what
> they need :-)
I think that description is false. At a certain point in the
management
You can use an union if the column types match
{...off the top of my head...}
select id, title, added as sortcol from table1
union
select id, headline, datetime as sortcol from table2
order by sortcol
limit 25;
John
CSN wrote:
I have two tables:
items: id, title, added, ...
news: id, headlin
CSN wrote:
I have two tables:
items: id, title, added, ...
news: id, headline, datetime, ...
I'd like to select the latest 25 combined records from both tables. Is there a
way to do this
using just select?
Thanks,
csn
Maybe something like this?
select id,title_headline,dt
from (
select
I have two tables:
items: id, title, added, ...
news: id, headline, datetime, ...
I'd like to select the latest 25 combined records from both tables. Is there a
way to do this
using just select?
Thanks,
csn
__
Do You Yahoo!?
Tired of spam? Yahoo
On Wed, Sep 20, 2006 at 11:19:29AM -0400, Jack Orenstein wrote:
> Thanks for all your help with the memory management problems. Next
> problem: I'm having problems converting from a char* to a Datum and back
> again.
>
> I have a char* which I need as a Datum, for use with a plan returned
> from S
On Wed, 2006-09-20 at 14:08 -0400, Tom Lane wrote:
> David Fetter <[EMAIL PROTECTED]> writes:
> > What would be involved in making INSERT/UPDATE/DELETE ... RETURNING be
> > on the same level as other table-like things such as VALUES (...),
> > ..., (...)?
>
> Getting rid of their side-effects, whi
David Fetter <[EMAIL PROTECTED]> writes:
> What would be involved in making INSERT/UPDATE/DELETE ... RETURNING be
> on the same level as other table-like things such as VALUES (...),
> ..., (...)?
Getting rid of their side-effects, which of course ain't happening.
The problem is the surrounding q
On Wed, Sep 20, 2006 at 01:42:59PM -0400, Tom Lane wrote:
> Jeff Davis <[EMAIL PROTECTED]> writes:
> > I was trying to use an INSERT ... RETURNING as a subselect in 8.2. Is
> > that possible?
>
> No.
What would be involved in making INSERT/UPDATE/DELETE ... RETURNING be
on the same level as other
On Wed, Sep 20, 2006 at 09:05:00AM -0400, AgentM wrote:
> On Sep 19, 2006, at 23:57 , Merlin Moncure wrote:
>
> >I have seen a steady progressive rise in the number of postgresql
> >related jobs and the quality of those jobs. Major companies are
> >apparently rolling out critical infrastructure
I wrote:
> "Harry Hehl" <[EMAIL PROTECTED]> writes:
>> The restore fails with:
>> psql:x:384: ERROR: foreign key constraint "accepttaskevent" cannot be
>> implemented
>> DETAIL: Key columns "accepttaskevent" and "objectid" are of
>> incompatible types: public.ds_uuid and public.ds_uuid.
> This
Jeff Davis <[EMAIL PROTECTED]> writes:
> I was trying to use an INSERT ... RETURNING as a subselect in 8.2. Is
> that possible?
No.
regards, tom lane
---(end of broadcast)---
TIP 4: Have you searched our list archives?
"Jack Orenstein" <[EMAIL PROTECTED]> writes:
> I have a char* which I need as a Datum, for use with a plan returned
> from SPI_prepare, so I'm doing this:
> char* string;
> Datum d;
> ...
> d = DirectFunctionCall1(textin, CStringGetDatum(string));
> ...
> ereport(WARNING, (
I was trying to use an INSERT ... RETURNING as a subselect in 8.2. Is
that possible?
jdavis=# create table foo(i int);
CREATE TABLE
jdavis=# insert into foo(i) values(1) returning i;
i
---
1
(1 row)
INSERT 0 1
jdavis=# select * from (insert into foo(i) values(1) returning i) t;
ERROR: syntax e
Thanks for all your help with the memory management problems. Next
problem: I'm having problems converting from a char* to a Datum and back
again.
I have a char* which I need as a Datum, for use with a plan returned
from SPI_prepare, so I'm doing this:
char* string;
Datum d;
...
d =
"Harry Hehl" <[EMAIL PROTECTED]> writes:
> The restore fails with:
> psql:x:384: ERROR: foreign key constraint "accepttaskevent" cannot be
> implemented
> DETAIL: Key columns "accepttaskevent" and "objectid" are of
> incompatible types: public.ds_uuid and public.ds_uuid.
This seems to be a vari
On Wed, Sep 20, 2006 at 11:02:46AM -0400, Jack Orenstein wrote:
> >http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/mmgr/README?rev=1.9
>
> Thank you, that is a useful document. So let me make sure I understand:
>
> - My C function is invoked in a MessageContext (which you refer
Merlin Moncure wrote:
I have seen a steady progressive rise in the number of postgresql
related jobs and the quality of those jobs. Major companies are
apparently rolling out critical infrastructure on postgresql...Vonage
is one example:
That is good news, I wish there where some of those Post
On Wed, 20 Sep 2006, Tom Lane wrote:
> Tomasz Ostrowski <[EMAIL PROTECTED]> writes:
> > Now for inserting data to a bytea we need 5*data_size in a buffer for
> > escaped data representation. 6*data_size if we do PQescapeByteaConn
> > in one chunk.
>
> If you send the value as an out-of-line binar
On 9/20/06, Martijn van Oosterhout wrote:
On Tue, Sep 19, 2006 at 04:00:43PM -0400, Jack Orenstein wrote:
> Can you provide some guidance (or point to some documentation) on how
> to manage memory? Is the idea that I should (must?) not pfree
> palloc'ed memory from Int64GetDatum, but I should fr
I'm hoping to see the parameters of prepared statements in the
postgresql log when using a JDBC client against postgresql 8.1?
I saw a post about using the V2 protocol.
Is there any downside to this?
Thanks,
Kevin
P.S. Looking at the driver documentation, I see that I can append the
protoc
[EMAIL PROTECTED] writes:
> Not yet, but i will try this one too. Anything special i should look for
> when dumping out the bad pages?
"If we knew what it was we would learn, it wouldn't be research" ...
regards, tom lane
---(end of broadcast)-
set LISTNAME digest
Hello all!
Ok, i found out some more informations. According to
http://h2.www2.hp.com/bizsupport/TechSupport/Document.jsp?lang=en&cc=us&;
taskId=110&prodSeriesId=397634&prodTypeId=15351&prodSeriesId=397634&objectID
=PSD_EX050119_CW01 one of our four disks in the server has a firmware issue.
Th
I am using the following commands to dump and then restore a database.
pg_dump -Fp "${PGDATABASE}" > "${BACKUPFILE}"
psql --variable ON_ERROR_STOP=1 -f "${BACKUPFILE}"
The restore fails with:
psql:x:384: ERROR: foreign key constraint "accepttaskevent" cannot be
implemented
DETAIL: Key colum
Hello Tom!
Not yet, but i will try this one too. Anything special i should look for
when dumping out the bad pages?
-- Matthias
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
> Sent: Wednesday, September 20, 2006 4:32 PM
> To: [EMAIL PRO
Tomasz Ostrowski <[EMAIL PROTECTED]> writes:
> Now for inserting data to a bytea we need 5*data_size in a buffer for
> escaped data representation. 6*data_size if we do PQescapeByteaConn
> in one chunk.
If you send the value as an out-of-line binary parameter then you don't
need any of that. See
[EMAIL PROTECTED] writes:
> invalid page header in block 437702 of relation ""
I concur with Scott that this sounds suspiciously like a hardware
problem ... but have you tried dumping out the bad pages with
pg_filedump or even just od? The pattern of damage would help to
confirm or disprove t
On Wed, 20 Sep 2006, [EMAIL PROTECTED] wrote:
> Any ideas how i could check the hardware?
1. memtest86 or memtest86+ at least 8 hours
2. CPU Burn-in
http://users.bigpond.net.au/cpuburn/ at least 8 hours
3. badblocks -s -v -t random /dev/sd%
WARNING: this will destroy your data!
4. smartctl -a
Hello Scott!
Thank you. Memtest86 i know. I think we will use this for testing our
hardware too.
Got some other nice information meanwhile from someone also running a DL380
server which had a defect backplane causing similar issues.
He also gave me the hint that there's a test suite CD by Compaq t
On Wed, 2006-09-20 at 15:14 +0200, [EMAIL PROTECTED] wrote:
> Hello Scott!
>
> Thank you for the quick answer. I'll try to check our hardware which is a
> Compaq DL380 G4 with a batteyr buffered write cache on our raid controller.
> As the system is running stable at all i think it's not the cpu o
On Wed, 20 Sep 2006, Tomasz Ostrowski wrote:
> I've made some experiments with attached program and
> came up that for inserting 1kB of data this program needs about
> 5120kB of virtual memory, 1MB - 10MB, 10MB - 55MB.
Forgot to attach it.
Pozdrawiam
Tometzky
--
Best of prhn - najzabawniejsze t
I'd like to propose something which would make an easy way for memory
efficient insertion/retrieval of bytea data.
Now for inserting data to a bytea we need 5*data_size in a buffer for
escaped data representation. 6*data_size if we do PQescapeByteaConn
in one chunk. I've made some experiments with
Hello Scott!
Thank you for the quick answer. I'll try to check our hardware which is a
Compaq DL380 G4 with a batteyr buffered write cache on our raid controller.
As the system is running stable at all i think it's not the cpu or memory.
At moment i tend more to a bad disk or SCSI controller but
On Sep 19, 2006, at 23:57 , Merlin Moncure wrote:
I have seen a steady progressive rise in the number of postgresql
related jobs and the quality of those jobs. Major companies are
apparently rolling out critical infrastructure on postgresql...Vonage
is one example:
(http://jobsearch.monster.c
On Wed, 2006-09-20 at 14:34 +0200, [EMAIL PROTECTED] wrote:
> Hello!
>
> We're running the latest release of PostgreSQL 7.4.13 on a Debian Sarge
> machine. Postgres has been compiled by oureselves.
> We have a pretty big database running on this machine, it has about 6.4 GB
> approximately. One ta
Hello!
We're running the latest release of PostgreSQL 7.4.13 on a Debian Sarge
machine. Postgres has been compiled by oureselves.
We have a pretty big database running on this machine, it has about 6.4 GB
approximately. One table contains about 55 million rows.
Into this table we insert about 5000
Andrew Kelly wrote:
On Tue, 2006-09-19 at 10:26 -0400, Tom Lane wrote:
Naz Gassiep <[EMAIL PROTECTED]> writes:
For something like Vista
compatibility, if you want to be taken seriously by anyone who uses
Windows (hands up anyone who knows a Windows user), "scratch your own
itch" is not really
On Tue, 2006-09-19 at 10:26 -0400, Tom Lane wrote:
> Naz Gassiep <[EMAIL PROTECTED]> writes:
> > For something like Vista
> > compatibility, if you want to be taken seriously by anyone who uses
> > Windows (hands up anyone who knows a Windows user), "scratch your own
> > itch" is not really goin
On Tue, Sep 19, 2006 at 04:00:43PM -0400, Jack Orenstein wrote:
> Can you provide some guidance (or point to some documentation) on how
> to manage memory? Is the idea that I should (must?) not pfree
> palloc'ed memory from Int64GetDatum, but I should free anything I
> allocate myself using palloc?
There are a few options depending on your needs.
PGCluster, Slony and pgpool would be the main ones to look at.
More info on them can be found at http://pgfoundry.org
Searching for replication will find more results than cluster
On 20/9/2006 14:17, "Samad, Alex" <[EMAIL PROTECTED]> wrote:
>
70 matches
Mail list logo
