. This is a workaround for point (2) but does not remedy point (1)
above.
Many thanks
Phillip
Phillip Smith
Thanks Pavel,
Is this the only way?. I would prefer to use a collation setting if this is
possible. Do you know whether there would be a performance hit using non
standard character strings?
Phillip
?
Regards
Phillip
Phillip
On 6 August 2010 16:08, Torsten Zühlsdorff f...@meisterderspiele.de wrote:
I receive my oh wow when i do the same things in Postgres like in MySQL:
Writting some procedures, triggers and use foreign key. The oh wow was
that it just *works*. After some years of using MySQL this is a very
On 5 August 2010 11:54, andi astowo andi.ast...@ymail.com wrote:
At this oppurtinity we ask for your support to give us informations regarding
the bellow questionaires. First, how can we have our data of the Postgre 7
under Red Hat Linux 7.2 to be used by the Postgre 8 under RHEL 5?.
On Wednesday 10 March 2010 18:32:41 Scott Marlowe wrote:
On Tue, Mar 9, 2010 at 11:49 PM, Phillip Berry
pbe...@stellaconcepts.com wrote:
Hi Everyone,
We're in the market for a new DB server to replace our current one (yes
it's one of *those* questions) ;).
It'll have quad core
Hi Everyone,
We're in the market for a new DB server to replace our current one (yes it's
one of *those*
questions) ;).
It'll have quad core Xeons, 36GB RAM and some sort of Raid 10 configuration.
Our provider is pushing us towards 6 x SATA II disks in a Raid 10 configuration
or 4 x SAS
Hi Everyone,
Just wondering what the maximum reasonable free space map setting should be?
I'm receiving the
following advice from vacuum:
INFO: free space map contains 170803 pages in 117 relations
DETAIL: A total of 185000 page slots are in use (including overhead).
733008 page slots are
or even
negative returns by setting the fsm too high?
Cheers
Phil
On Wednesday 17 December 2008 13:02:21 Grzegorz Jaśkiewicz wrote:
On Wed, Dec 17, 2008 at 12:55 AM, Phillip Berry
pbe...@stellaconcepts.com wrote:
I thought 185K was pretty high, is going to 700K+ reasonable? I've got
On Friday 12 December 2008 03:59:42 Tom Lane wrote:
Greg Smith gsm...@gregsmith.com writes:
On Thu, 11 Dec 2008, Phillip Berry wrote:
I'm not running PITR and checkpoint_segments is set to 100 as this is
home to a very write intensive app.
That's weird then. It shouldn't ever keep
Hello Everyone,
I've got a bit of a problem. It started last night when postgres (8.1.9) went
down citing the need
for a vacuum full to be done due to the transaction log needing to wraparound.
So I stopped the server, logged in using a standalone backend and started a
vacuum full analyze on
Dec 2008, Phillip Berry wrote:
I've got a bit of a problem. It started last night when postgres
(8.1.9) went down citing the need for a vacuum full to be done due to
the transaction log needing to wraparound.
Not exactly. What it said was To avoid a database shutdown, execute a
full
That example also reports that it uses the index. Only the is true
variation insists on seq. scan.
On Thu, Jun 26, 2008 at 4:08 PM, Lennin Caro [EMAIL PROTECTED] wrote:
use this
explain analyze select * from result where active = 't';
--- On *Thu, 6/26/08, Phillip Mills [EMAIL PROTECTED
On Wed, Jun 25, 2008 at 10:55 PM, Scott Marlowe [EMAIL PROTECTED]
wrote:
Until you benchmark it for your app you really don't know how
inefficient it really is compared to pessimistic locking.
Sure. The question was about more about finding the right approach/layer
for implementing
On Wed, Jun 25, 2008 at 10:21 PM, Craig Ringer [EMAIL PROTECTED]
wrote:
You might want to look into advisory locking. If your locks don't need
to be longer than the life of an active EntityManager session then you
can probably just issue a native query through the EntityManager to
acquire
Under somewhat unusual circumstances, rows in one of our tables have an
'active' flag with a true value. We check for these relatively often since
they represent cases that need special handling. We've found through
testing that having a partial index on that field works well. What seems
odd to
I'm working on an application that uses EJB3 entities in JBoss, with
Hibernate and a PostgreSQL database. One of the entity tables needs
consistent, synchronized updates to rows in an environment where telling the
user that their operation failed and starting over is not an option.
Because it's
We have a center in Europe who has just started to use PostgreSQL and was
asking me if there are any Symantec product or other products that backup
this type of database.
It doesn't appear to. I've just been through the whole rigmarole of
BackupExec for some Windows Servers, and I couldn't
07, 2007 2:48 PM
To: phillip
Cc: pgsql-general@PostgreSQL.org
Subject: Re: [GENERAL] failing to start posgresql.
take a look inside the rpm and see what it installed:
rpm -ql rpmname
On Thu, Jun 07, 2007 at 10:51:59AM +0200, phillip wrote:
hie i am a newbie to Postgresql. I installed
hie i am a newbie to Postgresql. I installed Postgresql using an rpm. my
problem is that when i issue the service postgresql start command the
database is failing to start. Where can i get the error logs for the
database so that i can see what is the problem. Is there a another way of
starting it
Where are you trying to execute these commands? They should be run at
the command line as they are 'standalone' programs, not SQL commands to
be run in an SQL session.
On Mon, 2007-05-07 at 10:01 +0100, kannan kk wrote:
hello
when i try to execute createdb,psql,pg_dump,pg_restore and similar
The most cumbersome part of our many (hundreds) of unit tests that
verify our data access is working, is creating and then deleting all
of the test data. Currently, we're doing it at a pretty high level
using java and our ORM (hibernate). It occurred to me that I can
probably speed the
to see I am not lying.
Phillip Pan
---
I have tried the function gethostbyname(text), which should return an inet value
or reference. However, it gave me something like unprintable
sql#= select gethostbyname('www.postgres.org');
Anyone got any clue?
Phillip Pan
---
?
Phillip Pan
---
Hello,
When I do (as postgres):
bash$ psql mydb
I get:
Connection to database 'mydb' failed.
FATAL 1: cannot create init file pg_internal.init
I'm not out of disk space. What's wrong? Where is it trying to create these
files? Is it a permissions issue? Is it a libraries problem? Mine are in:
26 matches
Mail list logo