?
Regards
Phillip
Phillip
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
osts regarding using LOWER function
for querying. This is a workaround for point (2) but does not remedy point (1)
above.
Many thanks
Phillip
Phillip Smith
On 6 August 2010 16:08, Torsten Zühlsdorff 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
> uncommon feeling, ev
On 5 August 2010 11:54, andi astowo 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?. Secondly,
> if above con
On Wednesday 10 March 2010 18:32:41 Scott Marlowe wrote:
> On Tue, Mar 9, 2010 at 11:49 PM, Phillip Berry
>
> 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) ;
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 disks
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
>
> wrote:
> > I thought 185K was pretty high, is going to 700K+ reasonable? I've got
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 re
On Friday 12 December 2008 03:59:42 Tom Lane wrote:
> Greg Smith 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'
Thursday 11 December 2008 15:20:21 you wrote:
> On Thu, 11 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
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
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';
>
> --
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
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
> acqu
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 pessi
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 t
> 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 f
: 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
On Thu, Jun 07, 2007 at 10:51:59AM +0200, phillip wrote:
> hie i am a newbie to Postgresql. I installed Postgresql using an rpm.
&
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 simil
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 dele
u do a '\df' at prompt, you will be able to see I am not lying.
Phillip Pan
---
In psql, gethostbyname() is defined as taking a text parameter and return an
inet type value or reference.
However, if you do
psql=# select gethostbyname('www.postgres.org');
gethostbyname
---
(1 row)
the inet address will be unprintable.
Has anyone got any idea?
Phillip Pan
---
I have tried the function gethostbyname(text), which should return an inet value
or reference. However, it gave me something like
sql#= select gethostbyname('www.postgres.org');
Anyone got any clue?
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
