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.
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
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, Kris
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
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
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
I have a table that looks like this:
Table public.hd
Column |Type
|Modifiers
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
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 positive
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] writes
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 RECORD;
BEGIN
select
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
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
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 looks
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
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
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;
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
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
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
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 tar'd dump file
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
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
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
__
Kris Kiger
Software Developer
Digonex Technologies, Inc.
317.638.4174 Fax
CONFIDENTIALITY NOTICE: The information in this transmission is private,
confidential, may be legally privileged, is property of the sender and is intended
solely for the use of the addressee. If you
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
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:
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?
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
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
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
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'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
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
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
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 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
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
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
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
42 matches
Mail list logo