- Original Message -
From: "Andre Schubert"
>
> Can i do a select id from foo order by id desc limit 1 before the end of
> the transaction,
> does this return exactly the row i inserted for this transaction?
>
only if u use SERIALIZABLE transaction isolation level - then the
transaction
- Original Message -
From: "Judy Jecelin"
>
> Hi,
>
> A relatively novice user of PostgreSQL but not
> of other databases... I'm trying to understand the
> use of initlocationI understand having separate
> data storage areas (perhaps for each database
> in your postmaster), but is th
- Original Message -
From: "Jean-Luc Lachance"
> Interesting... What happens when you drop and recreate the index???
>
repeat the whole procedure again
hth,
Marin
"...what you brought from your past, is of no use in your present. When
you must choose a new path, do no
- Original Message -
From: "Bruce Young"
> where can i find good information about postgresql datafiles.
> on how to manage them for better performance. ex: putting indexes on
> separate disks and so forth.
> any help and suggestions appreciated
>
this was discussed 2 days ago - browse
- Original Message -
From: "Mr OCP"
>
> Are there any tools to collect benchmark statistics for postgresql
database,
> we want to do testing with different configurtions to see which
> configuration is optimal for our database. We have a huge database in
> postgres running under Solars 7
