> The part about cache incoherency is very true, the _only_ cache coherency
> NFS offers is _only_ in the v3 spec, and is specifically called 'wcc'
> 'weak cache coherency' (afaik). So yes, you can expect differnent
> NFS clients to get different inconsistant views on heavily modified
> files unl
On Fri, 9 Feb 2001, adb wrote:
> I've heard of other people running databases on a Netapp Filer
> I think this is generally ok because the netapp has a special
> write cache in NVram and that's what makes it so fast.
>
yeah, basically a write returns almost instantaneously (or much closer
than
Shaw Terwilliger wrote:
> Besides dumping and COPY'ing the data into the second server, is there
> another form of easy one-way replication available? My schema has just
> a few simple tables (six tables, a few rows each). But these tables
> may hold a few million records each. I've estimated t
I've heard of other people running databases on a Netapp Filer
I think this is generally ok because the netapp has a special
write cache in NVram and that's what makes it so fast.
On Fri, 9 Feb 2001, tc lewis wrote:
>
> On Fri, 9 Feb 2001, Shaw Terwilliger wrote:
> > I've been using PostgreSQL
I dont' know if this a bug or I am just out of my mind, but since it
works with other RDBMS's I decided to ask, so here it goes:
I am trying to do the following:
SELECT distinct 'mod_type' ,currval('mytable_idmytable_seq') from
mytable;
and I get the message:
ERROR: Unable to identify an
* Shaw Terwilliger <[EMAIL PROTECTED]> [010209 16:18] wrote:
> Alfred Perlstein wrote:
> > Actually NFS has very strong write ordering semantics, it just has
> > terrible cache coherency. Meaning two machines accessing the same
> > file will most likely see different things if the file is updated
Steve Wolfe wrote:
> They may want to put the data on a file server, so that it gets backed up,
> and has the advantage of a hardware fault-tolerant RAID array. Tht has it's
> merits, but I don't think it woul dbe that great for performance. We spent
> the money to put another RAID array in th
On Fri, 9 Feb 2001, tc lewis wrote:
>
> On Fri, 9 Feb 2001, Shaw Terwilliger wrote:
> > I've been using PostgreSQL for a few years now in various projects, and
> > I've been very happy with its features and performance.
> >
> > I have a client who wants to know how PostgreSQL (7) will perform
On Fri, 9 Feb 2001, Shaw Terwilliger wrote:
> I've been using PostgreSQL for a few years now in various projects, and
> I've been very happy with its features and performance.
>
> I have a client who wants to know how PostgreSQL (7) will perform over
> NFS. The NFS client is Solaris, the server
Alfred Perlstein wrote:
> Actually NFS has very strong write ordering semantics, it just has
> terrible cache coherency. Meaning two machines accessing the same
> file will most likely see different things if the file is updated
> moderately.
I'm not an NFS guru by any means, but I've noticed ep
Alfred Perlstein wrote:
> NFS == Not F** Stable, don't do it. :) Any DBA will want to
> hurt you when he hears about you running a production DB over NFS.
Well, I thought it wasn't a very safe thing to do. Their network
administrator (the guy who buys machines, schedules backups, etc.)
sug
Bruce Momjian wrote:
> It is not performance I would be concerned about, but reliability. NFS
> has no state for reliability. I have to ask why they are using NFS
> rather than putting it on a drive local to the machine. If they say
> they want to share the data between two machines, that is ev
* Tom Lane <[EMAIL PROTECTED]> [010209 15:40] wrote:
> Shaw Terwilliger <[EMAIL PROTECTED]> writes:
> > I have a client who wants to know how PostgreSQL (7) will perform over
> > NFS. The NFS client is Solaris, the server is a big network storage=20
> > appliance. The network is probably gigabit
> It is not performance I would be concerned about, but reliability. NFS
> has no state for reliability. I have to ask why they are using NFS
> rather than putting it on a drive local to the machine. If they say
> they want to share the data between two machines, that is even crazier.
They m
Shaw Terwilliger <[EMAIL PROTECTED]> writes:
> I have a client who wants to know how PostgreSQL (7) will perform over
> NFS. The NFS client is Solaris, the server is a big network storage=20
> appliance. The network is probably gigabit ethernet.
> My first reaction is to tell them they're just
* Shaw Terwilliger <[EMAIL PROTECTED]> [010209 15:12] wrote:
> I've been using PostgreSQL for a few years now in various projects, and
> I've been very happy with its features and performance.
>
> I have a client who wants to know how PostgreSQL (7) will perform over
> NFS. The NFS client is Sol
-- Start of PGP signed section.
> I've been using PostgreSQL for a few years now in various projects, and
> I've been very happy with its features and performance.
>
> I have a client who wants to know how PostgreSQL (7) will perform over
> NFS. The NFS client is Solaris, the server is a big net
I've been using PostgreSQL for a few years now in various projects, and
I've been very happy with its features and performance.
I have a client who wants to know how PostgreSQL (7) will perform over
NFS. The NFS client is Solaris, the server is a big network storage
appliance. The network is p
Can you create a full text index on more than one
column in a table?
Culley
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
"Thomas T. Thai" <[EMAIL PROTECTED]> writes:
> why does this happen?
>
> -- Forwarded message --
> Date: Thu, 8 Feb 2001 10:46:59 -0600 (CST)
> From: Mail Delivery Subsystem <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Returned mail: see transcript for details
>
> The
Today I noticed that the swap used on my system was > 120M, and it seems
to be coming from the postmaster:
USER %CPU %MEM VSZ RSS STAT START TIME COMMAND
postgres 0.0 0.0 16680 SW2000 0:00 [pg_ctl]
postgres 0.1 1.1 135840 1528 S 2000 134:56 /usr/bin/postmaster
Hi,
I don't know what programming language you are using but there's
surely a function named quote which will do that for you.
With perl DBI you can use it like this :
quote :
Quote a string literal for use as a literal value in an SQL statement
by
escaping any special characters (such
On Fri, 9 Feb 2001, Oleg Lebedev wrote:
> I am using postgresql to store data passed from a web page. A user may
> enter whatever text she wants on that web page. Do I have to prepend all
> the illegal characters in the text with backslashes before storing the
> text in the database? Is there any
Hi,
This syntax is also available with Oracle regarding user grants on
tables. I have made a program who can parse Pg and Oracle
database so I have met this problem. Fortunally I have the source
code so I simply hack the code :-) I don't know about Visio but seeing
the operating system you probab
Hello,
I am using postgresql to store data passed from a web page. A user may
enter whatever text she wants on that web page. Do I have to prepend all
the illegal characters in the text with backslashes before storing the
text in the database? Is there any way to make postgresql prepend these
ille
I am trying to get Visio (5.5 Enterprise) on Win98/NT to talk with
Postgres 7.0.2 on Linux 2.2.16 via the Win32 driver from Insight
Distributions. The problem that I am having is that I get parse errors
on all queries to the database. The reason is the rather "odd" way in
which fields are specifie
Dear colleagues,
I have a sh-script which run pg_dump by hand successfully. But
I have no results when I run this script using crontab. Unfortunately, I'm
new for Postgres and even have no idea, what the matter. I can't get
any error log.
Please, help me.
Here is my sh-sc
27 matches
Mail list logo
