Hello,
Is there a way to know how many pages were hit by a Bitmap Heap scan ?
For instance :
Bitmap Heap Scan on posts
(cost=56.71..295.24 rows=2123 width=67)
(actual time=0.575..1.462 rows=2160 loops=1)
I'd like to know if it hit 2160 pages (ie I should really run CL
am Wed, dem 25.04.2007, um 1:14:15 -0400 mailte Tom Lane folgendes:
> Ben <[EMAIL PROTECTED]> writes:
> > I'm considering re-architecting a database to make use of many, many
> > schemas over time, it would probably grow to be on the order of 3,000
> > or so, with each schema holding ~100 t
am Tue, dem 24.04.2007, um 14:19:05 -0700 mailte finecur folgendes:
> Hi,
>
> Here is my first table:
>
> Table1
>
> name| ids
> -
> Peter| 2, 3, 4, 5
> Jack| 100, 34, 3
>
> Both name and ids are in text format.
>
> Here is my second table
>
> Table2
>
> id | Flag |
Angva <[EMAIL PROTECTED]> writes:
> In running a query I receive the error:
> ERROR: variable not found in subplan target lists
Please provide a complete test case.
regards, tom lane
---(end of broadcast)---
TIP 6: explain
Mike Goldner <[EMAIL PROTECTED]> writes:
> Is there any way to increase the debug logging or issue a query so that
> I could find the actual select statements that are idle?
Huh? "Idle in transaction" means there *isn't* any active SQL statement
--- those backends are waiting for the next client
Ben <[EMAIL PROTECTED]> writes:
> I'm considering re-architecting a database to make use of many, many
> schemas over time, it would probably grow to be on the order of 3,000
> or so, with each schema holding ~100 tables. Is that an absurd amount, or
> well within postgres' limits? I haven't
Hi,
Apparently, the amount of free space on the partition makes a big
difference in performance. I went from about 30% free space to about
5% and this triggered the performance issues. As soon as freed up
the drive to about 30% free space again the performance issues went
away.
Benjam
Hi,
Here is my first table:
Table1
name| ids
-
Peter| 2, 3, 4, 5
Jack| 100, 34, 3
Both name and ids are in text format.
Here is my second table
Table2
id | Flag | Title
-
2 | Red| good
3 | Blue | poor
4 | Green| middle
id is in integer (seri
On Monday 23 April 2007 01:21, Mageshwaran wrote:
> Hi ,
>
> I am new to postgresql, I have been assigned a task of upgrading
> postgresql to higher version.
> In our company we are using 7.1.1,7.1.3,7.4.5 versions of postgresql,
> can you please tell me which is the stable and suitable version in
In running a query I receive the error:
ERROR: variable not found in subplan target lists
The version is 8.1.5
I can find references to this message. Seems there was a bug in older
versions. Should I be finding this in 8.1.5? Any advice?
Thank you and much appreciated.
Mark
On Apr 23, 4:11 pm, [EMAIL PROTECTED] wrote:
> On Apr 23, 2:10 am, [EMAIL PROTECTED] (Martijn van Oosterhout) wrote:
>
>
>
> > On Mon, Apr 23, 2007 at 12:31:32AM -0400, Tom Lane wrote:
> > > [EMAIL PROTECTED] writes:
> > > > When I try to initiate tsearch2 in 8.2.4, I got the following error.
> > >
On Apr 23, 2:10 am, [EMAIL PROTECTED] (Martijn van Oosterhout) wrote:
> On Mon, Apr 23, 2007 at 12:31:32AM -0400, Tom Lane wrote:
> > [EMAIL PROTECTED] writes:
> > > When I try to initiate tsearch2 in 8.2.4, I got the following error.
> > > ERROR: incompatible library "/usr/local/pgsql/lib/tsearch
On Apr 23, 12:31 am, [EMAIL PROTECTED] (Tom Lane) wrote:
> [EMAIL PROTECTED] writes:
> > When I try to initiate tsearch2 in 8.2.4, I got the following error.
> > ERROR: incompatible library "/usr/local/pgsql/lib/tsearch2.so":
> > missing magic block
>
> Apparently you have a pre-8.2 version instal
Roger,
This statement runs but the table isnt actually updated. Slightly odd.
I ran the subquery, which makes perfect sense and nothing was
returned. If I remove the AND temp.id <> junctions.id part I get loads
of results returned but if I run the update with the the adjusted
subquery I get ERROR:
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Marcelo de
Moraes Serpa
Sent: dinsdag 24 april 2007 21:06
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Audit-trail engine: getting the
application's layer
guys,
i want to log some data everyday. for this i can do 1 of 2 things:
1) i can create an empty 'template' table and copy it everyday before
data logging including defaults.
# including constraints (thanks greg) doesn't work but more on that later.
helps-
i avoid spending more time on lengthy
I am experiencing a blocking situation in my database (Postgresql 8.1.8
on Redhat). When I do a "ps -ef|grep postgres" I see two processing
that are "idle in transaction" and they stay there indefinitely.
I'm running JBoss (the problem is in JBossMQ) and I'm having trouble
pinpointing the locatio
"Marcelo de Moraes Serpa" <[EMAIL PROTECTED]> writes:
> Hey guys,
>
> Mine is an web application - three tier. The app connects to the db using
> only one user and it has it's own authentication system and doesn't
> rely on the database for user management.
I solved the problem using a C program
> Well, that makes sense: if the shutdown took more than a
> minute then the
> "stop" script action would give up waiting, and then the
> "start" action
> would see the postmaster running and go away happy. (It's a bit odd
> that "service start" actions are supposed to treat "already running"
>
I'm considering re-architecting a database to make use of many, many
schemas over time, it would probably grow to be on the order of 3,000
or so, with each schema holding ~100 tables. Is that an absurd amount, or
well within postgres' limits? I haven't been able to find any information
on w
Am Dienstag, 24. April 2007 21:43 schrieb Jonathan Vanasco:
> Is it possible at all to use conditional joins in views?
>
> ie:
> select a.* , b.* from a inner join b ON ( (a.id = b.id) AND
> (a.otherfield <> ?) )
>
> I have a few 15-20 table joins that i'd like to push into views.
> i've neve
I have a server running Windows Server 2003 32-bit that has 8GB of
memory. Our system administrator installed PAE (Physical Address
Extensions) which I know MS SQL Server will use, but I'm not sure if
PostgreSQL will.
Can PostgreSQL use the memory above 2GB and 4GB?
-
Is it possible at all to use conditional joins in views?
ie:
select a.* , b.* from a inner join b ON ( (a.id = b.id) AND
(a.otherfield <> ?) )
I have a few 15-20 table joins that i'd like to push into views.
i've never wanted to push something with a conditional join into a
view before
"Marcelo de Moraes Serpa" <[EMAIL PROTECTED]> writes:
> @Richard: I've thought about having one DB user for each APP user. However,
> a coworker told me that it would infeasible to do that on the web
> enviroment, specifically for J2EE where a DB connection pool is used, so I
> gave up on that.
W
On Tue, 2007-04-24 at 09:02 +0530, Mageshwaran wrote:
> Hi ,
>
> I want to do replication using WAL , please tell the methods by which
> log shipping is done ie moving the wal files to slaves and executing it.
http://www.postgresql.org/docs/8.2/interactive/continuous-archiving.html
--
Brad Nic
Thank you for the replies.
@Richard: I've thought about having one DB user for each APP user. However,
a coworker told me that it would infeasible to do that on the web
enviroment, specifically for J2EE where a DB connection pool is used, so I
gave up on that.
@Jorge: Is this "connection id" you
"Marcelo de Moraes Serpa" <[EMAIL PROTECTED]> writes:
> I forgot to add the link to the article I've mentioned:
>
> http://www-128.ibm.com/developerworks/db2/library/techarticle/0302stolze/0302stolze.html#section2b
>
> This is what I'd like to do on PostgreSQL,
So, translating it to a simpler exa
Marcelo de Moraes Serpa wrote:
Here's what I need to do: Somehow save the user_id of the **application**
user who have done the update/delete action to the log row.
I've read an article on IBM's developer site which teaches how to do just
that (get the application's user id and save it the aud
On Tuesday 24 April 2007 10:57, "Michael Nolan" <[EMAIL PROTECTED]> wrote:
> Can WAL files be used to create/update a warm standby on a different
> minor version of PostgreSQL (eg, using files from a server running 8.2.3
> on an 8.2.4 server, or vice-versa?)
>
> I suspect this is a FAQ, but I didn
hi all,
I installed postgresql 8.2.3 in a freebsd server, my client application is
written in C++ builder + zeoslib and I haven't any problem until now, but now
with 8.2.3 version I have many connection that remains in FIN_WAIT_2, any
suggest?
regards,
Enrico
---(end of
"George Pavlov" <[EMAIL PROTECTED]> writes:
> i have examined the stop() and start() and i think i understand why the
> stop() reported a failure (it took to long), but i don't understand how
> the start() could have reported success:
>> Stopping postgresql service: [FAILED]
>> Starting postgresql
Can WAL files be used to create/update a warm standby on a different minor
version of PostgreSQL (eg, using files from a server running 8.2.3 on an
8.2.4 server, or vice-versa?)
I suspect this is a FAQ, but I didn't see it in the docs on WALs and PITR
(section 23.3)
--
Mike Nolan
Thanks for the quick response, i think will try it with python or perl.
Cheers,
Andy
On 24/04/07, Richard Huxton <[EMAIL PROTECTED]> wrote:
Andy Dale wrote:
> Hi,
>
> I wanted to setup a simple "generic" type trigger. What a mean by
generic
> is that i don't want to hardcode the
> NEW. or O
> > So it looks like the STOPPING of the service actually
> > succeeded, albeit
> > it took a while (more than the usual sessions open?). The
> > STARTING is
> > the one that actually failed (is that because the STOP was still in
> > process?). The question is why -- in a RESTART situation
> > w
I forgot to add the link to the article I've mentioned:
http://www-128.ibm.com/developerworks/db2/library/techarticle/0302stolze/0302stolze.html#section2b
This is what I'd like to do on PostgreSQL,
Thanks,
Marcelo.
On 4/24/07, Marcelo de Moraes Serpa <[EMAIL PROTECTED]> wrote:
Hey guys,
I
Martijn van Oosterhout <[EMAIL PROTECTED]> writes:
> The only time the server will wait for a time out is if the server and
> the client are on different machines and something disrupts actual
> communications.
Right, you need connectivity loss to create an issue --- a client
program crash doesn't
> I am trying to use cursors and I am really frustrated already. Do I
> need to install an extension?
No, it's all in the documentation:
http://www.postgresql.org/docs/current/static/plpgsql-control-structures
.html#PLPGSQL-RECORDS-ITERATING
> 1. Problem number one is that what ever I use in fro
Andy Dale wrote:
Hi,
I wanted to setup a simple "generic" type trigger. What a mean by generic
is that i don't want to hardcode the
NEW. or OLD. calls, i searched for a way to loop over
the NEW/OLD rowtypes but could not figure out how it should be done.
Don't use plpgsql - that's the secret.
On Tue, Apr 24, 2007 at 05:35:09PM +0200, Andy Dale wrote:
> Hi,
>
> I wanted to setup a simple "generic" type trigger. What a mean by generic
> is that i don't want to hardcode the
> NEW. or OLD. calls, i searched for a way to loop over
> the NEW/OLD rowtypes but could not figure out how it shou
On Tue, Apr 24, 2007 at 07:16:38AM -0700, Jeff Lanzarotta wrote:
> OK, that is what the other fellow said... It depends on the TCP/IP
> stack...
>
> Thanks again for the clarification.
Note, there are two cases. If only the program crashes but the system
is fine, the kernel will close the socket
Hi,
I wanted to setup a simple "generic" type trigger. What a mean by generic
is that i don't want to hardcode the
NEW. or OLD. calls, i searched for a way to loop over
the NEW/OLD rowtypes but could not figure out how it should be done.
This led me to attempt to do it in a way which i think is
In response to Brad Nicholson <[EMAIL PROTECTED]>:
> On Wed, 2007-04-18 at 16:43 -0400, Bill Moran wrote:
> > In response to "Drew Myers" <[EMAIL PROTECTED]>:
> > >
> > > I've been given a task to build a couple of geographically separate
> > > servers, which are capable of replicating data betwe
On Wed, 2007-04-18 at 16:43 -0400, Bill Moran wrote:
> In response to "Drew Myers" <[EMAIL PROTECTED]>:
> >
> > I've been given a task to build a couple of geographically separate
> > servers, which are capable of replicating data between each other.
> >
> > I've surfed through various google re
Don't forget to cc: the mailing list.
Peter Neu wrote:
Hello,
thanks for the fast reply. This works. I don't really need the dumpall
because I usually just back up one db.
I noticed the dump is now a binary file. Means that I will have to migrate
to 7.4.17 if this is the preferable release b
OK, that is what the other fellow said... It depends on the TCP/IP
stack...
Thanks again for the clarification.
--- Magnus Hagander <[EMAIL PROTECTED]> wrote:
> On Tue, Apr 24, 2007 at 06:55:12AM -0700, Jeff Lanzarotta wrote:
> > OK, thanks. I figured the server would at some point in time clear
On Apr 19, 2007, at 3:21 PM, Kevin Murphy wrote:
Has anybody tried making a 64-bit PostgreSQL on an Apple XServe w/
Intel Woodcrest CPU's? My compile works, but the 'make check'
fails because of failure to allocate shared memory. There's
plenty of SYSV memory available.
The call to shm
On Tue, Apr 24, 2007 at 06:55:12AM -0700, Jeff Lanzarotta wrote:
> OK, thanks. I figured the server would at some point in time clear the
> connection up, my question now is when does that happen? Any idea how
> long the connection sit around before the server cleans it up? Someone
> else said poss
Hey guys,
I needed to implement an audit trail engine and decided to do it on the
database layer.
I already have a basic but fully functional audit trail system implemented
on my PostgreSQL 8.2 server. It has been done using PL/PGSQL
and triggers and it works pretty well.
Here's what I need to
OK, thanks. I figured the server would at some point in time clear the
connection up, my question now is when does that happen? Any idea how
long the connection sit around before the server cleans it up? Someone
else said possibly an hour...
--- Magnus Hagander <[EMAIL PROTECTED]> wrote:
> On Tue
Jeff Lanzarotta wrote:
Hello,
I am writing an application that reads information from my PostgreSQL
database. If I cause the program to crash and the program ends without
gracefully disconnecting from the database, there is an open connection
still left in the database.
How does the PostgreSQL
On Tue, Apr 24, 2007 at 05:53:02AM -0700, Jeff Lanzarotta wrote:
> Hello,
>
> I am writing an application that reads information from my PostgreSQL
> database. If I cause the program to crash and the program ends without
> gracefully disconnecting from the database, there is an open connection
> s
Peter Neu wrote:
Hello,
I have a problem with backing up a database. The original db runs on a SuSE
ES 9 box in Unicode. Version 7.4.2
If you're keeping this installation, see about upgrading to the latest 7.4.x
The recovery db is supposed to run on a windows xp box. The encoding is
UTF-8. V
Dear Mr. Bill Moran,
Thank you for your answer.
1) To be more clear I would like to construct a query using the reldatabase
column. In that query you quoted I can't identify the reldatabase column. I
want a query that will help me to list how many buffers are used by each
database
In response to "Sorin N. Ciolofan" <[EMAIL PROTECTED]>:
>
> Dear all,
>
> About the pg_buffercache view:
> I couldn't find the description for this view in the manual at
> http://www.postgresql.org/docs/8.2/interactive/catalogs.html
> However I found the readme file provided in the /contrib./pg_
Anton Andreev wrote:
> Hi,
>
> I am trying to use cursors and I am really frustrated already. Do I
> need to install an extension?
No, you just need to have a look at the docs.
http://www.postgresql.org/docs/8.2/static/plpgsql-control-structures.html#PLPGSQL-RECORDS-ITERATING
> 1. Problem numbe
I did already, but this still does not help me write a simple while loop
that goes through all data and stops at the last row.
Joris Dobbelsteen wrote:
See the postgresql documentation at:
http://www.postgresql.org/docs/8.2/interactive/plpgsql-cursors.html
-Original Message-
Fro
Hello,
I am writing an application that reads information from my PostgreSQL
database. If I cause the program to crash and the program ends without
gracefully disconnecting from the database, there is an open connection
still left in the database.
How does the PostgreSQL server handle clients tha
Hello,
I have a problem with backing up a database. The original db runs on a SuSE
ES 9 box in Unicode. Version 7.4.2
The recovery db is supposed to run on a windows xp box. The encoding is
UTF-8. Version 8.1
On the linux box I did:
pg_dumpall > outfile
On the windows box I did:
psql -f outfi
Hi,
I am trying to use cursors and I am really frustrated already. Do I
need to install an extension?
1. Problem number one is that what ever I use in front of the fetch
command it is not being accepted, it gives a syntax error. If I use a
number ,"all" or "forward" it gives an error again?
Pat Maddox wrote:
Sounds like theoretically it could matter, but in practice it doesn't.
I'd like a more definite answer though.
Well, most of the locking issues with Slony seem to be with
administrative commands (setting up a replication set, altering it)
which require taking locks. If your
Sounds like theoretically it could matter, but in practice it doesn't.
I'd like a more definite answer though.
You could ask the slony guys directly ;) They'd know a lot more about it
than the pg-general list would.
http://lists.slony.info/mailman/listinfo
--
Postgresql & php tutorials
htt
On 4/24/07, Richard Huxton <[EMAIL PROTECTED]> wrote:
Pat Maddox wrote:
> I want to start using slony for replication, and have a question about
> setting table IDs when creating replication sets. The docs say that
> you have to be careful in what IDs you assign to the tables - if
> there's a re
Dear all,
About the pg_buffercache view:
I couldn't find the description for this view in the manual at
http://www.postgresql.org/docs/8.2/interactive/catalogs.html
However I found the readme file provided in the /contrib./pg_buffercache of
the source code for version 8.2.3
Here it's written the
On 4/24/07, Mageshwaran <[EMAIL PROTECTED]> wrote:
I want to do replication using WAL , please tell the methods by which
log shipping is done ie moving the wal files to slaves and executing it.
Not possible at the moment: the log shipping facility that was
introduced in 8.2 only lets you set up
On Tue, 24 Apr 2007 11:14:43 +1200
"Andrej Ricnik-Bay" <[EMAIL PROTECTED]> wrote:
> On 4/24/07, Felix Kater <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > the messages returned by PQerrorMessage() contain a trailing new
> > line. So, they doesn't nicely integrate into strings formatted by
> > printf.
My colleague who speaks more C than me came up with the code below
which works fine for us. Will the memory allocated for lexeme be freed
Nice, except self-defined utf8 properties. I think it will be much better to use
pg_mblen(char*). In this case your dictionary will work with any supported by
Benjamin Arai wrote:
> Hi,
>
> I upgraded to 8.2.4 but there was no significant change in performance.
> I did notice that hte query appears to be executed incorrectly.
> I have pasted the EXPLAIN ANALYZE below to illustrate:
>
> =# explain analyze select s_content,textdir from (SELECT * from
>
Pat Maddox wrote:
I want to start using slony for replication, and have a question about
setting table IDs when creating replication sets. The docs say that
you have to be careful in what IDs you assign to the tables - if
there's a relationship between two tables, the parent needs to have a
lowe
68 matches
Mail list logo
