Bruce Momjian <[EMAIL PROTECTED]> writes:
> Hey, I have an idea. Can we do subtransactions as separate transactions
> (as Tom mentioned), and put the subtransaction id's in the WAL, so they
> an be safely committed/rolledback as a group?
It's not quite that easy: all the subtransactions have to
Hi,
I managed to drop really important table. Fortunately, I had a backup of
the table (raw file, not a ascii file). After putting that table into
freshly initdb'd database, postgres doesn't see new transactions even
though 'vacuum' sees the tuples alright.
So, question. I'd like to force
Larry Rosenman <[EMAIL PROTECTED]> writes:
> CREATE FUNCTION "nowminus" (interval) RETURNS timestamp with time zone AS 'SELECT
>now() - $1;' LANGUAGE 'sql';
Right idea, but you need to mark it iscachable.
regards, tom lane
---(end of broadcast)--
Bruce Momjian <[EMAIL PROTECTED]> writes:
> I am confused why we can't implement subtransactions as part of our
> command counter? The counter is already 4 bytes long. Couldn't we
> rollback to counter number X-10?
That'd work within your own transaction, but not from outside it.
After you comm
> I have an external search engine system which plugs in to postgres. I use a few
> C functions to interface the search daemon with the Postgres back-end.
>
> The best that I have been able to do is do a "select" for each result. I have a
> live demo/test site:
>
> http://www.mohawksoft.com/sear
Larry Rosenman <[EMAIL PROTECTED]> writes:
> EXPLAIN
> SELECT ...
> FROM attack_db
> WHERE (start_time >= now() - '02:00:00'::interval OR
> end_time >= now() - '02:00:00'::interval)
> AND host(src_ip) NOT IN (select host(ip) from exempt_ips)
> AND host(dst_
On Fri, May 18, 2001 at 06:10:10PM -0700, Mikheev, Vadim wrote:
> > Vadim, can you remind me what UNDO is used for?
>
> Ok, last reminder -:))
>
> On transaction abort, read WAL records and undo (rollback)
> changes made in storage. Would allow:
>
> 1. Reclaim space allocated by aborted transac
"Mikheev, Vadim" <[EMAIL PROTECTED]> writes:
>> Vadim, can you remind me what UNDO is used for?
> Ok, last reminder -:))
> On transaction abort, read WAL records and undo (rollback)
> changes made in storage. Would allow:
> 1. Reclaim space allocated by aborted transactions.
> 2. Implement SAVEP
Thomas Lockhart <[EMAIL PROTECTED]> writes:
>> I suggest that the current code is more correct than you think ;-).
>> ISTM it is a good idea to require a units field, or at least some
>> punctuation giving a clue about units --- for example I do not object to
>> '08:00' being interpreted as hours
> Vadim, can you remind me what UNDO is used for?
Ok, last reminder -:))
On transaction abort, read WAL records and undo (rollback)
changes made in storage. Would allow:
1. Reclaim space allocated by aborted transactions.
2. Implement SAVEPOINTs.
Just to remind -:) - in the event of error di
"Mikheev, Vadim" <[EMAIL PROTECTED]> writes:
>> If a tuple is dead, we care not whether its index entries are still
>> around or not; so there's no risk to logical consistency.
> What does this sentence mean? We canNOT remove dead heap tuple untill
> we know that there are no index tuples referen
> I see postgres 7.1.1 is out now. Was the fix for this
> problem included in the new release?
I fear it will be in 7.2 only.
> On Thursday 29 March 2001 20:02, Philip Warner wrote:
> > At 19:14 29/03/01 -0800, Mikheev, Vadim wrote:
> > >> >Reported problem is caused by bug (only one tuple
> v
> I have been thinking about the problem of VACUUM and how we
> might fix it for 7.2. Vadim has suggested that we should
> attack this by implementing an overwriting storage manager
> and transaction UNDO, but I'm not totally comfortable with
> that approach: it seems to me that it's an awfully
Will anyone object if I change the calling convention for operator
selectivity estimation functions (oprrest, oprjoin entries in
pg_operator)?
Historically the call conventions have been
double oprrest(Oid opid, Oid relid, AttrNumber attno,
Datum value, int32 flag);
double oprjo
Jan Wieck <[EMAIL PROTECTED]> writes:
> Patch applied.
How about some documentation?
regards, tom lane
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Anyone know what the default password is for the postgres user? When
trying to use createuser, the password for the postgres user is asked. What
is that default password? I searched all through the docs but couldn't find
it.
Thanks.
---(end of broadcast)---
Oleg Bartunov <[EMAIL PROTECTED]> writes:
>> The comment says
>>
>> ** Take a compressed entry, and install it on a page. Since we now know
>> ** where the entry will live, we decompress it and recompress it using
>> ** that knowledge (some compression routines may want to fish around
>> ** on t
I've been going talking with the SGI technical support about some of the
errors I got when compiling Postgres 7.1.1 on SGI IRIX 6.5.12 with the
MIPSPro 7.3 C compiler. I've already mentioned that somehow the compiler
can't see the correct definition for strdup (I believe she thought that
it was du
On Thu, May 17, 2001 at 12:43:49PM -0400, Rod Taylor wrote:
> Best way to upgrade might bee to do something as simple as get the
> master to master replication working.
Master-to-master replication is not simple, and (fortunately) isn't
strictly necessary. The minimal sequence is,
1. Start a b
Thomas Lockhart <[EMAIL PROTECTED]> writes:
>> We have recently upgraded from 7.0.3 to 7.1 and a query which used
>> to work is no longer working.
>> The query does an avg on an interval column and now gets the error:
>> ERROR: Bad interval external representation '0'
> OK, there is one case of
Oleg Bartunov <[EMAIL PROTECTED]> writes:
> On Thu, 17 May 2001, Tom Lane wrote:
>> We will also want to look at upgrading the non-btree index types to allow
>> concurrent operations.
> am I right you plan to work with GiST indexes as well ?
> We read a paper "Concurrency and Recovery in Generali
> > > I am looking at adding an index tuple flag to indicate when a
> > > heap tuple is expired so the index code can skip looking up the heap tuple.
> > >
> > > The problem is that I can't figure out how be sure that the heap tuple
> > > doesn't need to be looked at by _any_ backend. Right no
> There was some discussion of doing that, but it fell down on the little
> problem that in normal index-search cases you *don't* know the heap tid
> you are looking for.
I can not follow here. It does not matter if you don't know a trailing
part of the key when doing a btree search, it only he
set digest
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
"jacky_shu" <[EMAIL PROTECTED]> writes:
> I am a novice in postgreSQL.So i want to get ODBC driver
> to connect with my program.
http://www.unixodbc.org/
> Is there somebody can tell me where the driver can download.Or how
> to connect postgreSQL with PHP page in linux.
You can find PHP rpms
Zeugswetter Andreas SB <[EMAIL PROTECTED]> writes:
> It was my understanding, that the heap xtid is part of the key now,
It is not.
There was some discussion of doing that, but it fell down on the little
problem that in normal index-search cases you *don't* know the heap tid
you are looking for
> A particular point worth making is that in the common case where you've
> updated the same row N times (without changing its index key), the above
> approach has O(N^2) runtime. The indexscan will find all N index tuples
> matching the key ... only one of which is the one you are looking for o
Zeugswetter Andreas SB <[EMAIL PROTECTED]> writes:
> foreach tuple in heap that can be deleted do:
> foreach index
> call the current "index delete" with constructed key and xtid
See discussion with Hiroshi. This is much more complex than TID-based
delete and would be faster
Hello everyone:
I am a novice in postgreSQL.So i want to get ODBC driver
to connect with my program.Is there somebody can tell me
where the driver can download.Or how to connect postgreSQL
with PHP page in linux.Thanks.
--
JACKY HSU
Mail:[EMAIL PROTECTED]
S
Hi,
Haven't looked at this for a while, but I think some larger issues might raise
their (ugly?) heads here.
Domains are effectively types that inherit attributes of parent type, with
some additional information, so should be handled at the level of pg_type.
However might make sense to look at s
Hi all (I hope this is the correct list),
Under Oracle there is v$parameter which list ALL config varables. Under
psql there is the SHOW command, but this only lists 1 variable. I have
written a shell script (attached) that shows ALL know variables. My
questions is can this script get included
> > Isn't current implementation "bulk delete" ?
>
> No, the index AM is called separately for each index tuple to be
> deleted; more to the point, the search for deletable index tuples
> should be moved inside the index AM for performance reasons.
Wouldn't a sequential scan on the heap ta
When organizing available free storage for re-use, we will probably have
a choice whether to favor using space in (mostly-) empty blocks, or in
mostly-full blocks. Empty and mostly-empty blocks are quicker -- you
can put lots of rows in them before they fill up and you have to choose
another.
Hannu Krosing <[EMAIL PROTECTED]> writes:
>> Irrelevant, not to mention already done ...
> Do you mean that we already can do just analyze ?
In development sources, yes. See
http://www.ca.postgresql.org/devel-corner/docs/postgres/sql-analyze.html
regards, tom lane
---
John Reid <[EMAIL PROTECTED]> writes:
>> Ugh. Don't overload pg_class with things that are not tables. I see no
>> reason that either pg_class or pg_attribute should be involved in the
>> definition of a domain. Make new system tables if you need to, but
>> don't confuse the semantics of critic
>> I am looking at adding an index tuple flag to indicate when a
>> heap tuple is expired so the index code can skip looking up the heap tuple.
>>
>> The problem is that I can't figure out how be sure that the heap tuple
>> doesn't need to be looked at by _any_ backend. Right now, we update the
36 matches
Mail list logo
