Dear Expert,
I got a trouble withLOCK on my table
(Inquery table).
I've put the LOCK (using select bla.bla for
update)
on trigger(trigger insert) of Table_A. It's work
properly.
when i tried "insert into Table_A bla.bla.bla"
with more
than 5 user in same time
Hello, All!
I'm planing to upgrade from 7.2.1 to 7.3.4.
Will pg_dumpall and pg_restore be sufficient for propper data migration?
Mark
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
Hi,
I have a weird problem and want to know if I understand what's happening.
I have a table like this:
create table statistics (
dateDATE DEFAULT current_date,
key TEXT,
value INTEGER DEFAULT 0,
UNIQUE(date, key)
);
and I have a
Hi,
I've done some work with databases, but nothing extreme.
I just got assigned the setting up of what I'd call a
high-reliability site, as opposed to high-availability --
which I'd like too, of course :-)
I've got some ideas on how to acheive my goal, but I fear I'm
not quite up-to-date on the
David F. Skoll [EMAIL PROTECTED] writes:
What appears to be happening is this:
1) Sometimes, a whole bunch of clients try updating the same row. I
see sevaral postgresql processes marked UPDATE waiting
Any process that arrives at the row and finds it already modified by
some concurrent
Hello!
Please help me!!
My pgsql installation is having a problem during startup and I don't konw
how to solve it. postmaster is reporting this:
LOG: database system shutdown was interrupted at 2003-09-04T
LOG: checkpoint record is at 0/44C3FC0
LOG: redo record is at 0/44C3FC0; undo record is
On Tue, 2 Sep 2003, Marc G. Fournier wrote:
okay, first off ... what URL? I've been working on, and testing, archives
all week, and altho getting things down below a 2min search appears to be
near impossible (anyone know something *better* then mnogosearch that will
handle 250k URLs and
On Thu, 4 Sep 2003, Tom Lane wrote:
Any process that arrives at the row and finds it already modified by
some concurrent transaction will wait for that concurrent transaction
to complete.
Right. And it waits on a semaphore, right? So there's no way to
use select() to wait for EITHER the
David F. Skoll [EMAIL PROTECTED] writes:
Which process does have the row lock, and why isn't it completing its
transaction?
I don't know the details of PostgreSQL's implementation, but it seems
that when lots of processes are waiting to update the same row, it
gets incredibly slow.
Hmm.
On Thu, 4 Sep 2003, David F. Skoll wrote:
Zapping clients that are in the middle of database operations is bad
design IMHO.
It's required. The clients are e-mail filters and they must reply
quickly, before the end of the SMTP transaction. If they take too long,
they must be killed so
please remove me from the list
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
On Thu, 4 Sep 2003, Yudha Setiawan wrote:
Dear Expert,
I got a trouble with LOCK on my table (Inquery table).
I've put the LOCK (using select bla.bla for update)
on trigger(trigger insert) of Table_A. It's work properly.
when i tried insert into Table_A bla.bla.bla with more
than 5 user in
On Thu, 4 Sep 2003, Sam Barnett-Cormack wrote:
It might be worth racking your brains to think of other ways. Query
timeouts?
Either way, if the back-end is waiting on a semaphore, will it time
out the query and terminate? The problem is lots of waiting back-end
processes.
why not make it
On Wed, 2003-09-03 at 15:21, Ian Huynh wrote:
while postgres is pretty solid under unixes,
i am just curious as regards to the stability of cygwin+Postgres combo under win2k?
Since Cygwin is an emulation layer running on Windows, performance of
PostgreSQL + Cygwin isn't comparable to a pure
Gastón Simone wrote:
Hello!
Please help me!!
My pgsql installation is having a problem during startup and I don't konw
how to solve it. postmaster is reporting this:
LOG: database system shutdown was interrupted at 2003-09-04T
LOG: checkpoint record is at 0/44C3FC0
LOG: redo record
Bruce Momjian [EMAIL PROTECTED] writes:
Gastón Simone wrote:
PANIC: XLogWrite: write request 0/44C4000 is past end of log 0/44C4000
LOG: startup process (pid 22347) was terminated by signal 6
LOG: aborting startup due to startup process failure
What PostgreSQL version are you using. If
Hi all.
I want to buy a book for postgresql administration but i do not know
which one. Can anybody suggest me one?
Thanks
Gvre
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining
5:44p
Dear All,
Is there any way by which we can restore the deleted column. Bcoz I have deleted a
column... and when I describe the contents I am seeing the column back again, but the
attribute name has been replaced with the system generated one.. and the structure
still remains the same.
Giannis Vrentzos wrote:
Hi all.
I want to buy a book for postgresql administration but i do not know
which one. Can anybody suggest me one?
Thanks
Gvre
Postgresql by DouglasDouglas has been very usefull to me...
--
Tom Van den Brandt
I try...
---(end of
go for it, point it at archives.postgresql.org though, since that is the
major part of the search engine
On Thu, 4 Sep 2003, scott.marlowe wrote:
On Tue, 2 Sep 2003, Marc G. Fournier wrote:
okay, first off ... what URL? I've been working on, and testing, archives
all week, and altho
Dear PostgreSQL admin'ers,
Our group at OSDL have been porting our DBT test kits to PostgreSQL.
In getting up to speed on PostgreSQL, we have not found a way to recover
from a serious database failure (disk corruption, disk/volume failure).
The following scenario described in the 7.3 docs
Hi everybody,
I'm trying to understand how vacuumdb and free
space map work together for retrieving free spaces after delete or update
statements.
max_fsm_pagesand max_fsm_relations
areset to default values (respectively 1 and 100).
I do my tests on a table containing at the
beginning
I have been trying to download the driver for
windows. When I finally get ontothe FTP server (or mirror) and get the
zipped msi it will not unzip. I have triedseveral versions of the file but
they are all the same. I am trying to use winzip.
Extracting to
"C:\removed"
Use Path: no Overlay
Hekko, All!
I'm planing to upgrade from 7.2.1 to 7.3.4.
Will pg_dumpall and pg_restore be sufficient for propper data migration?
Mark
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Hello,
today i updated my cygwin and now postgresql
not run! This is the error:
IpcMemoryCreate: shmget(key=5432001, size=1499136, 03600) failed: Function
not implemented
The newest Cygipc was installed (2.00)!
--
Thomas Wegner
---(end of
k, try the search engine now ... I just found a 'missing index' on one of
the critical tables, and I'm getting more realistic speeds on search
results ...
On Thu, 4 Sep 2003, Marc G. Fournier wrote:
go for it, point it at archives.postgresql.org though, since that is the
major part of the
Right. We need point-in-time-recovery. Someone is working on it and we
hope to have it for 7.5.
---
Mary Edie Meredith wrote:
Dear PostgreSQL admin'ers,
Our group at OSDL have been porting our DBT test kits to
IMHO, while point-in-time recovery would be great to have, there are many
applications that benefit from having online backup and recovery without
needing log roll-forward. For example, Oracle contrasts Full Database
Point-in-time Recovery, the feature mentioned by Bruce, with Tablespace
Point in
Murthy Kambhampaty wrote:
IMHO, while point-in-time recovery would be great to have, there are many
applications that benefit from having online backup and recovery without
needing log roll-forward. For example, Oracle contrasts Full Database
Point-in-time Recovery, the feature mentioned by
I was experimenting with moving some of my case logic out of the
application and into sql and found a strange EXPLAIN result with one of
my COALESCE statements. Why is each subselect listed twice? This is in
7.3.4 on freebsd 4.8.
cms3=# explain analyze select coalesce ((sELECT thumb FROM
On Thursday, September 04, 2003 18:12, Bruce Momjian
[mailto:[EMAIL PROTECTED]
Murthy Kambhampaty wrote:
...
I assume you are contrasting _any_ point-in-time recovery to recover up
to the crash point, right?
Right.
Anyway, unfortunately, WAL doesn't contain enough information
to recover
without
Murthy Kambhampaty wrote:
Anyway, unfortunately, WAL doesn't contain enough information
to recover
without having the file system files in some consistent state, even if
that state is old. In fact, the files have to be consistent as of the
last checkpoint.
This, I'm not so sure of. On
Is there a way to query the database to find out how old the current
table statistics are? That is, when the ANALYZE command was last run
on a given table? It seems like there ought to be a table somewhere
in pg_catalog I can't find it in the PostgreSQL Administrator
documentation, nor by
Josh Goldberg [EMAIL PROTECTED] writes:
I was experimenting with moving some of my case logic out of the
application and into sql and found a strange EXPLAIN result with one of
my COALESCE statements. Why is each subselect listed twice? This is in
7.3.4 on freebsd 4.8.
Prior to 7.4,
I have looked at the code and it seems VACUUM FULL does collect index
free space into the FSM via index_vacuum_cleanup(). Is that true?
---
Bruce Momjian wrote:
Bruce Momjian wrote:
AFAIK, VACUUM doesn't reclaim space
Bruce Momjian [EMAIL PROTECTED] writes:
I have looked at the code and it seems VACUUM FULL does collect index
free space into the FSM via index_vacuum_cleanup(). Is that true?
Yes.
regards, tom lane
---(end of
36 matches
Mail list logo