Greetings! I've been doing some research into log rotation software and
ran into this, while looking through the postgres site:
"There is a built-in log rotation program, which you can use by setting
the configuration parameter redirect_stderr to true in postgresql.conf."
http://www.postgresq
have been
archived, save the current one.
My question then is, how do we tell which wal log is X (the one
currently being written to)?
Jeff Frost wrote:
Kris,
It is invoked when the WAL file is filled. I believe the server
preallocates 8 or so of them on startup.
On Wed, 28 Sep 2005,
I've been playing around with recovery and am a bit confused as to
when this method gets invoked.
At the moment, I have two servers set up, both of them with postgres
installed. Lets call them server A and server B. Server A is running
postgres and processing transactions. Server B has
Howdy all. I'm doing some research on 'middleware' type connection
pooling, such as pgpool. I'm having some trouble finding other options
that are actively being maintained, whether it be by the open source
community or not. Can anyone point me to some other resources or ideas
for connection
Howdy all. I'm doing some research on 'middleware' type connection
pooling, such as pgpool. I'm having some trouble finding other options
that are actively being maintained, whether it be by the open source
community or not. Can anyone point me to some other resources or ideas
for connection
Quick question. I lock a table, call it table X, and then issue two
updates on that table. The two updates are left waiting. I then unlock
the table. The two updates go through. My question is, is there a
predictable way to determine which query will be executed first? Thanks
in advance
Heh, I see. The sequence currval was set lower than what was already in
the table. It just so happened we had holes in our data for the values
it was selecting. Thanks for pointing that out!
Kris
Michael Fuhr wrote:
On Thu, Mar 24, 2005 at 04:45:02PM -0500, Kris Kiger wrote:
I'm pos
I'm positive no one else has been in the database. There are two of us
who work on it and we have been side by side all afternoon. The problem
appears to be purely internal to the database. I'm running more tests
as we speak and we are still recieving the same sporadic errors. It
works for
I have a table that looks like this:
Table "public.hd"
Column |Type
|Modifiers
---+-+-
Interesting. That makes sense, though. So, is there a good way to lock
a set of rows using SELECT FOR UPDATE in plpgsql? I assume using
PERFORM would yield the same problem, because it immediately discards
the results.
Thanks!
Kris
Tom Lane wrote:
Kris Kiger <[EMAIL PROTECTED]>
In your second paragraph, I think that you are saying that SELECT FOR
UPDATE only locks one row, even though the select itself may return
many. Am I mis-interpreting you? Also, what do you mean by seizing on
a non-active row?
Your assumption about pkey_id is right, I meant for that to mean p
Tom Lane wrote:
Kris Kiger <[EMAIL PROTECTED]> writes:
Here is my problem. I have a function that is triggered on insert. For
simplicity's sake, lets say the function looks like this:
CREATE OR REPLACE FUNCTION dostuff_on_insert() RETURNS TRIGGER AS '
DECLARE lockrows RE
transaction_isolation
---
read committed
Running Postgres 7.4 btw
Kris
Tsirkin Evgeny wrote:
What transaction level are you using?
Evgeny.
Kris Kiger wrote:
Here is my problem. I have a function that is triggered on insert.
For simplicity's sake, lets say the function
Here is my problem. I have a function that is triggered on insert. For
simplicity's sake, lets say the function looks like this:
CREATE OR REPLACE FUNCTION dostuff_on_insert() RETURNS TRIGGER AS '
DECLARE lockrows RECORD;
BEGIN
select into lockrows * from table1 where pkey_id = NEW.pkey_id f
Hey all, its me again. If I do not do a count(product_id) on my
tsearch2 queries, its actually really fast, for example;
explain analyze SELECT product_id FROM product, to_tsquery('bear') AS q
WHERE vector @@ q LIMIT 1000;
QUERY PL
Oleg, the data I have right now was generated using a random paragraph
generator. The words are real words, but there are only 508 distinct
keywords in the 3,000,000 records that tsearch2 will pick up, using
default settings. I was using this data set for the purpose of testing
tsearch2's cap
Yes, it is much better than no index of sequential scan. We may just be
looking at the best performance tsearch2 can offer on my machine.
search_test=# explain analyze SELECT count(q) FROM product,
to_tsquery('oil') AS q WHERE vector @@ q;
Here is the explain analyze output, funny thing, after I ran josh's
query, mine ran a lot fastermaybe it forced a caching?;
search_test=# explain analyze select count(*) from product where vector
@@ to_tsquery('oil');
Aggregate (cost=6113.09..6113.09 rows=1 width=0) (actual
time=19643.372.
Hi all. I am doing some work with tsearch2 and am not sure what to
expect out of it, performance wise. Here is my setup:
Table "public.product"
Column| Type |Modifiers
-+--+---
Is there a way to install psql without having to install of the
postgresql source? Thanks!
Kris
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that
Steve,
Are the three SCSI drives raided? If so, I would move the operating
database to that machine. From what I understand it can be a real
hassle to setup/maintain sym-linked tables. If you don't have the option
to move the database, I would explore one of these two routes:
Route one
Thanks Tom, -Fc worked great! I appreciate your help.
Kris
Tom Lane wrote:
Kris Kiger <[EMAIL PROTECTED]> writes:
I've got a database that is a single table with 5 integers, a timestamp
with time zone, and a boolean. The table is 170 million rows in length.
The contents of the
I've got a database that is a single table with 5 integers, a timestamp
with time zone, and a boolean. The table is 170 million rows in length.
The contents of the tar'd dump file it produced using:
pg_dump -U postgres -Ft test > test_backup.tar
is: 8.dat (approximately 8GB), a toc, and resto
This looks exactly like what we want. Currently we are using JDBC to
maintain persistent connections. The advantage to this is that you can
use the JDBC driver written specifically for your version of Postgres
(level 1 or level 4, I forget which is the closest). Do you have any
idea how clos
Here is the scenario I am running into:
I have a cluster of databases. I also have another cluster of
machines that will have to talk with some of the database machines.
Rather than set up a connection to each databases from each of the
'talking' machines, is it possible to share a single co
it works like a charm.
Just curious if there is a reason for this order of operation. Thanks
Kris
__
Kris Kiger
Software Developer
Digonex Technologies, Inc.
317.638.4174 Fax
CONFIDENTIALITY NOTICE: The information in this transmission is private,
confidential, may be l
I am trying to restore a dump of two independant databases. Each
database is the same in table structure (there is only one table that
consists of 5 integers, a timestamp with time zone, and a boolean).
Here are the number of rows:
DB1 - 115,539,855 rows
DB2 - 118,022,948 rows
There ar
Has anyone heard of clusgres or, better yet, had any experience with it?
I came across it while searching for active clustering projects.
http://www.linuxlabs.com/clusgres.html
Thanks in advance for the info!
Kris
---(end of broadcast)---
TIP 6: Hav
I added a column to a table of type boolean and then set its default to
false. Next, I ran an update on the table that was very similar to this
one:
update tablename SET bool_field_name = false;
This error is returned:
ERROR: unrecognized replace flag: 88
Has anyone seen this before?
Tha
Is it possible to make a schema change to a dumped backup? I've
un-tarred the file and edited toc.dat and restore.sql, but when I
attempt to pg_restore the re-tarred file, I get an archiver out of
memory error.
This whole issue arose when I set a default in a table row equal to a
value that
Is there a way to force a shared object to reload? I've compiled a new
version of a .so, but postgres seems to be pulling the old version out
of memory. I've tried deleting the .so and recompiling it, but postgres
is insistant, for some reason, of using the old version. Any ideas?
Thanks for
I saw that Mammoth PostgreSQL Replicator was announced on
Postgresql.org. Just wondering if anyone has had any experience with it.
Kris
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregis
Is there a good way to store a query plan using libpq? Can someone
point me a good way, other than using SPI? Thanks!
Kris
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Hi all,
I've got a function in PG set up, the libpq C call goes like this:
PERFORM funcName(''t1'', ''t2'', ''t3'', ''t4'', NEW.someInteger,
NEW.someBoolean)
funcName looks like this:
create function funcName(text, text, text, text, int, boolean)
returns int as '/var/lib/postgres/
I'm trying to do a query: select ta.x from ta join tb using (y) where z
= 'somevalue' FOR UPDATE
Why can't this be executed without error in 7.3.x? It worked just fine
in 7.2.x. Thanks for the input
---(end of broadcast)---
TIP 8: explain anal
How do I direct logging output from stdout to a file? I'm using PG
7.3.4. Thanks for the help!
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
I have two databases set up, one designated as a master (w/database
named masterdb) and one designated as a slave (w/ database named
slavedb). My problem is that the two are inexplicably not replicating.
First, I checked the replication.cfg files on each machine to verify
that the master and s
Has anyone installed the ant_buildfile_upgrade for ERServer? I haven't
been able to find install instructions or figure it out since, for some
reason, the patch appears to be in XML. Any ideas? Thanks for the help
Kris
---(end of broadcast)
Does anyone know the status of the Postgres-R project and when it may
fall in with a current PostgreSQL release? Thanks for the help
Kris
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-
I ended up setting the path in the ld.so.conf file and it seems to work
just fine, thanks for all of your help!
Kris
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatyp
I have written a variation of one of the libpq C functions provided with
postgres. It compiles just fine, but when I try to execute the program
it reports the following error:
./a.out: error while loading shared libraries: libpq.so.3: cannot open
shared object file: No such file or directory
I would appreciate it if I could get some thoughts on indexing a field
with only two values? For example, I have a table with a few million
rows in it. All items in this table are broken up into two categories
using 'T' or 'F'. It seems logical to me that an index on this field
would create
I've installed postgres 7.3.3 on one of my debian machines. On other
installations postgres is started automatically on machine bootup.
However, on one installation it fails to do so. In fact, it doesn't
appear that PG tries to start at all durring the bootup process. I'm
still relatively ne
Here's my problem. I have user X calling a database function. The
function inserts data into table Y. User X only has select access to
this table. Is there some way to allow user X to call a function that
does an insert for him/her without user X having to have write access to
table Y? Is
Hi all, I'm looking for a good way to monitor disk I/O on a linux
system. Specifically, I would like to know when postgres is making
page-ins and page-outs. If anyone knows of a good utility, please let
me know! Thank you for the help
Kris
---(end of broadcast)
This will probably be a quick question for some of you with more
experience than I. When you define a trigger to occur before or after
an event, does this mean that the trigger is spawned as part of the
current event transaction, or is it completed as a seperate transaction
after the event is
46 matches
Mail list logo
