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 same time
Code...fm_In...fm_Out..
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
subscribe-nom
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
[ADMIN] unsubscrib
please remove me from the list
_
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com
---(end of broadcast)-
"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 concurre
please remove me from the list
_
Get a FREE computer virus scan online from McAfee.
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
---(end of broadcast)---
TIP 5: Have you
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 a
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 s
Running 7.3.2 under RedHat we suffered a disk crash. Following was
Postgres log output from after crash:
2003-09-04 08:46:12 [29550] LOG: connection authorized: user=postgres
database=gts
Found a pre-existing shared memory block (key 5434001, id 65538) still
in use.
If you're sure there are no
"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.
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 kille
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
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 *n
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
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 usi
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 column'
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.
Have
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 Douglas&Douglas 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 a
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 and
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_pages and max_fsm_relations
are set to default values (respectively 1 and 100).
I do my tests on a table containing at the
beginnin
I have been trying to download the driver for
windows. When I finally get onto the FTP server (or mirror) and get the
zipped msi it will not unzip. I have tried several versions of the file but
they are all the same. I am trying to use winzip.
Extracting to
"C:\"
Use Path: no Overlay File
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 broadcast)
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 P
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 i
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
"Marc Mitchell" <[EMAIL PROTECTED]> writes:
> Running 7.3.2 under RedHat we suffered a disk crash. Following was
> Postgres log output from after crash:
> 2003-09-04 09:24:51 [1873] LOG: redo starts at 0/B3129C68
> 2003-09-04 09:24:51 [1873] PANIC: Invalid page header in block 2696
> of 329
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 con
"Jouneau Luc" <[EMAIL PROTECTED]> writes:
> INFO: Pages 11944: Changed 11944, Empty 0; Tup 32: Vac 1931936, Keep 0, Un=
> Used 0.
> Total CPU 1.57s/1.90u sec elapsed 42.01 sec.
> It seems that FSM traced all of my deletes since it mentions removes in 864=
> 1+3303=3D11944 pages (>1 wh
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
>w
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 o
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 searchi
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 s
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 broadcast)-
41 matches
Mail list logo