Hello - Just installed 8.2.4 on a Solaris 9 box. It's an 8-way (15000
MHz sparc) with 32GB of ram. We don't know the exact table structure yet
or access patterns, although the first thing that will be looked at is a
Sesame triple store DB. I would expect that this DB will be more skewed
to read
Hello - Several people kindly responded directly to me with some
specific suggestions for this, however the message was mistakenly
deleted and not in the archives. If you remember who you are and
wouldn't mind resending that would be fantastic!
Thanks!
-Nate
Hello - Just installed 8.2.4 on a
Hello - Trying to find out how much floating point operation performance
effects Postgres in general. Looking at some lower power machines that
have good integer performance but not great floating point performance,
shared FPU across cpus. If we store, but don't use in query criteria,
floating
Hello - Does anyone happen to have a SQL script or function that can
reset all the sequence values found in a given DB? When we rebuild the
DB it would be handy to be able to set all the sequence back to a known
starting place.
Thanks!
-Nate
---(end of broadcast)
Hello - We are using PG_ADMIN backup to create the schema DDL scripts
for our application. Is there any way to get PGAdmin to not include the
encoding value or configure PostgreSQL to set the client encoding to
UNICODE? Having problems with the JDBC driver and the UTF8 encoding when
we try to e
Hello - Typically case of a software guy needing to spec hardware for a
new DB server. Further typified case of not knowing exact amount of data
and I/O patterns. So if you were to spec a disk system for a new general
purpose PostgreSQL server any suggestions of what to start with?
Details I h
Tom Lane wrote:
Nathan Wilhelmi <[EMAIL PROTECTED]> writes:
Hello - Trying to track down a lock contention problem, I have a process
that does a series of select / insert operations. At some point the
process grabs a series of RowExclusiveLock(s) and has the obvious effect
of st
Hello - Trying to track down a lock contention problem, I have a process
that does a series of select / insert operations. At some point the
process grabs a series of RowExclusiveLock(s) and has the obvious effect
of stalling other processes. I logged all the statements and don't see
any for up
Jan Wieck wrote:
On 2/12/2008 3:04 PM, Tom Lane wrote:
Nathan Wilhelmi <[EMAIL PROTECTED]> writes:
Hello - Trying to track down a lock contention problem, I have a
process that does a series of select / insert operations. At some
point the process grabs a series of RowExclusiveLock(
Hello - Curious if anyone has any experience with the new UUID type in
8.3? We are currently using sequences for all of our keys and ids.
However using a UUID instead of a sequence would make some parts of the
application easier. However we have a few concerns about performance
issues surroundi
Hello - Ran into an interesting problem last week with data unexpectedly
being deleted. Has anyone else experienced this and have any suggestions
on how to prevent this in the future?
Here is the environment:
Server: 8.0.3 on Solaris 9
JDBC Driver: 8.0.311
This is the series of statements tha
11 matches
Mail list logo
