Thanks!
Sanjay
Date: Fri, 2 May 2008 16:00:32 +0200
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
CC: pgsql-general@postgresql.org
Subject: Re: [GENERAL] High resolution PostgreSQL Logo
On Fri, May 02, 2008 at 03:32:29PM +0530, Sanjaya Kumar Patel
Hi,
I will have a log table which, once a day or so, is copied to a file
(for movement to a data warehouse), and the log table emptied. For
performance, the log table on the production system has no indexes,
and is write-only. (The unload process is the only reader.)
To unload it, I
Christophe [EMAIL PROTECTED] writes:
I will have a log table which, once a day or so, is copied to a file
(for movement to a data warehouse), and the log table emptied. For
performance, the log table on the production system has no indexes,
and is write-only. (The unload process is the
On May 3, 2008, at 9:56 AM, Tom Lane wrote:
This is
a great deal less efficient than TRUNCATE, but it's secure for
concurrent insertions, which TRUNCATE is definitely not.
Exactly my question; thank you!
-- Xof
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
Craig Ringer [EMAIL PROTECTED] writes:
Later on, though, less new space would have to be allocated because more
and more of the space allocated earlier to hold moved tuples would be
being freed up in useful chunks that could be reused.
I don't see how that works. If the minimum size of the
I'm creating some custom C functions to load dynamically from a dll
(this is Postgres 8.3.1 on Windows XP SP2). I have two that work fine,
but any time I try to write one that uses a text*, postgres crashes.
This is true even for the example functions like copytext given in the
documentation
Dan \Heron\ Myers [EMAIL PROTECTED] writes:
I'm creating some custom C functions to load dynamically from a dll
(this is Postgres 8.3.1 on Windows XP SP2). I have two that work fine,
but any time I try to write one that uses a text*, postgres crashes.
What cases have you gotten to work
Tom Lane wrote:
What cases have you gotten to work correctly?
My guess is that you're either messed up about V0 vs V1 calling
convention (ie you forgot PG_FUNCTION_INFO_V1, or added it when you
shouldn't have), or you've got some kind of problem with not detoasting
toasted input values.
I am having trouble revoking a user's create privilege on
schema public.
Here is the sequence of commands that demonstrates the problem:
[EMAIL PROTECTED]:~$ su
Password:
saturn:/home/jdietrch# su postgres
[EMAIL PROTECTED]:/home/jdietrch$ psql
Welcome to psql 8.3.1, the PostgreSQL interactive
I have an application developped by a third party which takes very
long to process all the queries.
I use Red Hat 4 and Postgre 8.2.7 on a 64 bit machine.
Checking the log files created by postgre I see that the program is
running always the same query:
execute unnamed: select
I have been creating some user defined C functions using minGW and
postgreSQL 8.3. Everything works great when I use integers,
timestamps, points, etc. I have compiled, linked, created, and tested
multiple function and aggregates.
The problem occurs when I have a text parameter and need to use
Hi, I am ruuning a database behind a webserver and there is a table
which is huge. I need to pull data from this table and send to user
through http. If I use
select * from huge_table where userid = 100
It will return millions of records which exhuasts my server's memory.
So I do this:
select *
One problem I've had in development recently is the inability to get the
aliased name of a table from a query. We're using a PHP framework for
querying, which internally uses pg_field_name to retrieve the select list
field name, which is great. There is alwo pg_table_name, to retrieve the
table
I am using a PL/pgSQL procedure. I am trying to hold the procedure
name in a table and then based on certain selection criteria get the
procedure name out of the table and execute it. I would like to pass a
row record, currently NEW, and retrieve the same rowtype. The
following code will compile
On May 2, 2008, at 2:01 PM, finecur wrote:
Hi, I am ruuning a database behind a webserver and there is a table
which is huge. I need to pull data from this table and send to user
through http. If I use
select * from huge_table where userid = 100
It will return millions of records which
Tom Lane wrote:
Craig Ringer [EMAIL PROTECTED] writes:
Later on, though, less new space would have to be allocated because more
and more of the space allocated earlier to hold moved tuples would be
being freed up in useful chunks that could be reused.
I don't see how that works. If the
tekwiz wrote:
Result:
DBD::Pg:st execute failed: ERROR: operator does not exist: money
integer
HINT: No operator matches the given name and argument type(s). You may
need to add explicit type casts.
CONTEXT: SQL statement SELECT (( $1 - $2 - $3 - $4 - $%) 0)
craig=# SELECT '0'::money 0;
Craig Ringer [EMAIL PROTECTED] writes:
Begin a transaction and free the first chunk (2 tuples in this case, but
obviously many more in a real case):
---
..473612058
---
Use that freed space to store the first ordered tuples:
---
014736.2.58
---
finecur wrote:
Hi, I am ruuning a database behind a webserver and there is a table
which is huge. I need to pull data from this table and send to user
through http. If I use
select * from huge_table where userid = 100
It will return millions of records which exhuasts my server's memory.
Is
Tom Lane wrote:
Anyway I think the main practical problem would be with deadlocks
against other transactions trying to update/delete tuples at the same
times you need to move them. Dealing with uncommitted insertions would
be tricky too --- I think you'd need to wait out the inserting
Dan \Heron\ Myers [EMAIL PROTECTED] writes:
One case that fails is essentially copied from the V1 section in the
documentation:
Well, there's nothing wrong with that C code, so the problem is
someplace else.
Did you remember to declare the function STRICT? If not, and if
there are any nulls
Scott Miller [EMAIL PROTECTED] writes:
One problem I've had in development recently is the inability to get the
aliased name of a table from a query. We're using a PHP framework for
querying, which internally uses pg_field_name to retrieve the select list
field name, which is great. There is
Thank you very much. Could you show me how to do it in JDBC?
Craig Ringer wrote:
finecur wrote:
Hi, I am ruuning a database behind a webserver and there is a table
which is huge. I need to pull data from this table and send to user
through http. If I use
select * from huge_table where
I was looking for some information on how write barriers interact with
software raid and ran across the following kernel thread referenced on LWN.
The suggestion is that fsync isn't really safe on Linux as it is currently
implented. (The thread was from February 2008, so it probably still
Dear list,
I'm looking for a function to output the elements of my array column in
rows ? Let's say I have following table:
id = integer
nam= array char varying
idnam
1 {nam1,nam2,nam3}
2{n1,n2}
I think there should be available a function to expand the elements of an
array of
Hi all
I have this function:
def checkNameDob(self, name, dob):
cur = self.conn.cursor();
sql = SELECT * from patient WHERE fn_pat = %s
cur.execute(sql,(name))
rows = cur.fetchall()
It seems to work fine, But I'm getting this exception:
psycopg2.ProgrammingError:
On Saturday 03 May 2008 4:05 pm, David Anderson wrote:
Hi all
I have this function:
def checkNameDob(self, name, dob):
cur = self.conn.cursor();
sql = SELECT * from patient WHERE fn_pat = %s
cur.execute(sql,(name))
rows = cur.fetchall()
It seems to work
Tom Lane wrote:
Well, there's nothing wrong with that C code, so the problem is
someplace else.
Did you remember to declare the function STRICT? If not, and if
there are any nulls in your test table, a crash would be expected;
there's nothing in this function that's guarding against a null
Ge Cong wrote:
Thank you very much. Could you show me how to do it in JDBC?
Here's one example. As I haven't been using JDBC directly it's probably
horrible, but it'll do the job. Any exception will terminate this
example, but in practice you'd want to catch and handle exceptions
Dan \Heron\ Myers [EMAIL PROTECTED] writes:
I'm wondering if maybe there is a dependency somewhere I'm missing. I
link with postgres.lib to create the dll;
Oh, you're using Windows :-(. I make it my business to not know
anything about that platform, but perhaps you could get a clue by
On Fri, May 2, 2008 at 9:13 AM, Javier Olazaguirre
[EMAIL PROTECTED] wrote:
I have an application developped by a third party which takes very long to
process all the queries.
I use Red Hat 4 and Postgre 8.2.7 on a 64 bit machine.
Checking the log files created by postgre I see that the
On Fri, May 2, 2008 at 9:34 AM, Scott Miller [EMAIL PROTECTED] wrote:
One problem I've had in development recently is the inability to get the
aliased name of a table from a query. We're using a PHP framework for
querying, which internally uses pg_field_name to retrieve the select list
field
32 matches
Mail list logo
