Quoting Tom Lane [EMAIL PROTECTED]:
Keith C. Perry [EMAIL PROTECTED] writes:
This might have been discussed before but I wanted to know if clustering
tables
by partial indexes will be availble in a later release of pgSQL?
What in the world would it mean to do that?
I'm not sure I
as:
iprism=# \d hrs_idx
Index public.hrs_idx
Column | Type
+--
stamp | timestamp with time zone
btree, for table public.report, predicate (thehour(stamp) = 0::double
precision AND thehour(stamp) = 23::double precision)
--
Keith C. Perry, MS E.E
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
--
Keith C. Perry, MS E.E.
Director
?
http://www.postgresql.org/docs/faq
--
Keith C. Perry, MS E.E.
Director of Networks Applications
VCSN, Inc.
http://vcsn.com
This email account is being host by:
VCSN, Inc : http://vcsn.com
---(end of broadcast
access via a public IP then it would more certainly be behind
another firewall that is NAT'ing/Port Forwarding its traffic.
--
Keith C. Perry, MS E.E.
Director of Networks Applications
VCSN, Inc.
http://vcsn.com
This email account is being host by:
VCSN, Inc
-windows platform to run your
production database.
--
Keith C. Perry, MS E.E.
Director of Networks Applications
VCSN, Inc.
http://vcsn.com
This email account is being host by:
VCSN, Inc : http://vcsn.com
---(end of broadcast
used?
--
Keith C. Perry, MS E.E.
Director of Networks Applications
VCSN, Inc.
http://vcsn.com
This email account is being host by:
VCSN, Inc : http://vcsn.com
---(end of broadcast)---
TIP 9: the planner
to the mailing list cleanly
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
--
Keith C. Perry, MS E.E.
Director of Networks Applications
VCSN
might want to
look into are JFS and ReiserFS.
--
Keith C. Perry, MS E.E.
Director of Networks Applications
VCSN, Inc.
http://vcsn.com
This email account is being host by:
VCSN, Inc : http://vcsn.com
---(end of broadcast
. Is there a better way?
Thanks to all in advance.
--
Keith C. Perry, MS E.E.
Director of Networks Applications
VCSN, Inc.
http://vcsn.com
This email account is being host by:
VCSN, Inc : http://vcsn.com
---(end of broadcast
Quoting Richard Huxton [EMAIL PROTECTED]:
Keith C. Perry wrote:
I have a table with with 1 million records in it. Here is the definition
CREATE TABLE report
(
match int4,
action varchar(16),
stamp timestamptz,
account varchar(32),
ipaddress inet,
profile
parameter).
If you are not on a network, you could install 7.4 version in a different
directory and configure to run on a different port. You still dump via IP this
way. You can run both systems head to head that way and see how things went.
Good luck-
--
Keith C. Perry, MS E.E.
Director of Networks
our the
http://techdocs.postgresql.org site to read about some more hands on and in
depth information. There is also http://gborg.postgresql.org where you can
download some of the other software tools, interfaces, etc that you may need
develope and deploy your applications.
--
Keith C. Perry, MS
shared hosting and dedicated hosting.
+1-503-667-4564 - [EMAIL PROTECTED] - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL
--
Keith C. Perry, MS E.E.
Director of Networks Applications
VCSN, Inc.
http://vcsn.com
Mysql 4.0.15)
Once again proof is in the pudding!
regards
Mark
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
--
Keith C. Perry, MS E.E.
Director of Networks Applications
VCSN, Inc.
http
for
somebody, whose last name ends with erry (as opposed to begins with
Perr).
Dima
Keith C. Perry wrote:
I wanted to know this too because I notice that using like with wildcards
appears to be similar to a regular expression in that the index is not used.
This is what I have
)
--
Keith C. Perry, MS E.E.
Director of Networks Applications
VCSN, Inc.
http://vcsn.com
This email account is being host by:
VCSN, Inc : http://vcsn.com
---(end of broadcast)---
TIP 5: Have you checked our
://www.postgresql.org/docs/faqs/FAQ.html
--
Keith C. Perry, MS E.E.
Director of Networks Applications
VCSN, Inc.
http://vcsn.com
This email account is being host by:
VCSN, Inc : http://vcsn.com
---(end of broadcast)---
TIP 5
a wish list somewhere.
--
Keith C. Perry, MS E.E.
Director of Networks Applications
VCSN, Inc.
http://vcsn.com
This email account is being host by:
VCSN, Inc : http://vcsn.com
---(end of broadcast)---
TIP 3
--
Keith C. Perry, MS E.E.
Director of Networks Applications
VCSN, Inc.
http://vcsn.com
This email account is being host by:
VCSN, Inc : http://vcsn.com
---(end of broadcast)---
TIP 3: if posting/reading through
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
--
Keith C. Perry, MS E.E.
Director of Networks Applications
VCSN, Inc.
http://vcsn.com
This email account is being host by:
VCSN, Inc : http
.
Not very scientific I know :)
Seriously though, when people indicate PG is hard, I hear, if it was easy
everone would be doing it.
-$0.02
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
--
Keith C. Perry, MS E.E.
Director
are NOT using Windows somewhere, and
an increasing number of organizations are starting understand OSS solutions. So
both world are merging so it not about avoiding and one thing. Its about
picking an choosing your battles.
Keith C. Perry wrote:
The way I look at it is that I probably don't
prohibitive. Then again, that might simply be the way they want it.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
--
Keith C. Perry, MS E.E
it. If you are using 7.4 you could
even use pg_dump with ssh in a similar manner.
--
Keith C. Perry, MS E.E.
Director of Networks Applications
VCSN, Inc.
http://vcsn.com
This email account is being host by:
VCSN, Inc : http://vcsn.com
Bruce's said his materials are on his web site so perhaps we
should start there with the intention of repackaging that information for
community distribution.
--
Keith C. Perry, MS E.E.
Director of Networks Applications
VCSN, Inc.
http://vcsn.com
This email
-tablespaces.htm
http://www-rohan.sdsu.edu/doc/oracle/server803/A54641_01/ch8.htm
-Original Message-
From: John Sidney-Woollett [mailto:[EMAIL PROTECTED]
Sent: Sat 12/13/2003 4:38 AM
To: Keith C. Perry
Cc: Bruce Momjian; Brian Maguire; [EMAIL
is Pg.pm
(http://gborg.postgresql.org/project/pgperl/projdisplay.php).
--
Keith C. Perry, MS E.E.
Director of Networks Applications
VCSN, Inc.
http://vcsn.com
This email account is being host by:
VCSN, Inc : http://vcsn.com
---(end
)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
I think that is what I was getting confused with before- schemas...
http://www.postgresql.org/docs/7.4/static/catalog-pg-namespace.html
--
Keith C. Perry, MS E.E.
Director of Networks Applications
VCSN, Inc.
http
Quoting Greg Stark [EMAIL PROTECTED]:
Keith C. Perry [EMAIL PROTECTED] writes:
Ok, thats for the response. I take it a PG namespace = Oracle table space
(or
namespace is simply the generic term).
Actually if you check back you'll notice you're the first person to say
namespace
on it. After reading/studying a training manual or guide, it should
be completely a personal choice.
--
Keith C. Perry, MS E.E.
Director of Networks Applications
VCSN, Inc.
http://vcsn.com
This email account is being host by:
VCSN, Inc : http://vcsn.com
)---
TIP 8: explain analyze is your friend
LOL, Bruce tell you what- I'm a pretty good cook. Maybe I'll talk to Drexel
about a catered certification event! That definitely be *bam* taking it up a
notch!!
--
Keith C. Perry, MS E.E.
Director of Networks Applications
VCSN, Inc.
http://vcsn.com
Quoting Peter Eisentraut [EMAIL PROTECTED]:
Keith C. Perry wrote:
That situtation is a little different though since Linux comes is
various distributions. Eventually people with get that Linux = Red
Hat is NOT true. Heck, IBM is probably the best at promoting Linux
these days
Quoting Marc G. Fournier [EMAIL PROTECTED]:
On Thu, 11 Dec 2003, Peter Eisentraut wrote:
Keith C. Perry wrote:
That situtation is a little different though since Linux comes is
various distributions. Eventually people with get that Linux = Red
Hat is NOT true. Heck, IBM is probably
is to (if
you can) use 7.4's pg_dump. Just setup the TCP/IP connectivity if you don't
have it already and dump using a superuser account.
--
Keith C. Perry, MS E.E.
Director of Networks Applications
VCSN, Inc.
http://vcsn.com
This email account is being host by:
VCSN
rarely write a complete page of
HTML. I just use perl to assemble those pieces based on user input and the
required business logic. The EIS is of course PostgreSQL.
--
Keith C. Perry, MS E.E.
Director of Networks Applications
VCSN, Inc.
http://vcsn.com
that I'm curious about.
--
Keith C. Perry, MS E.E.
Director of Networks Applications
VCSN, Inc.
http://vcsn.com
Quoting Jan Wieck [EMAIL PROTECTED]:
The following is more or less a brain-dump ... not finally thought out
and not supposed to be considered a proposal at this time
time. I've notice quite a few service providers on
the list. Some are probably listed on techdocs but I noticed my entry hasn't
shown up yet.
/shameless-plug
--
Keith C. Perry, MS E.E.
Director of Networks Applications
VCSN, Inc.
http://vcsn.com
This email
after second update
10.0
10.5
11.0
11.5
12.0
after 3rd update
10.0
10.25
10.5
11.0
11.5
12.0
after a renumbering
10
11
12
13
14
15
You'll want to vacuum after that renumbering as well.
--
Keith C. Perry, MS E.E.
Director of Networks Applications
VCSN, Inc.
http://vcsn.com
).
--
Keith C. Perry, MS E.E.
Director of Networks Applications
VCSN, Inc.
http://vcsn.com
This email account is being host by:
VCSN, Inc : http://vcsn.com
---(end of broadcast)---
TIP 6: Have you searched our
Quoting Keith C. Perry [EMAIL PROTECTED]:
Quoting Gianni Mariani [EMAIL PROTECTED]:
Gianni Mariani wrote:
Before I go deep into this - does anyone have the quick fix for this ?
Some facts - the 7.3.4 version of plperl.c has the same errors in the
7.4 tree.
The 7.4
Quoting Gianni Mariani [EMAIL PROTECTED]:
Keith C. Perry wrote:
I had this same issue as well but now I'm *slightly* concerned since most of
my
code is perl. How soon would issue be reviewed? (not that I'm NOT going to
use
your patch for right now).
I suspect that this is only
Quoting Peter Eisentraut [EMAIL PROTECTED]:
Keith C. Perry writes:
What am I missing?
A reproduceable test case.
--
Peter Eisentraut [EMAIL PROTECTED]
???
Ok, lets try the question this way...
What is a method of dumping and restoring a complete database cluster when
: [archiver] input file does not appear to be a valid archive
I'm also tried pg_restore with a 7.3.4 database file and the result was the same
on the 7.4 server.
What am I missing?
--
Keith C. Perry, MS E.E.
Director of Networks Applications
VCSN, Inc.
http://vcsn.com
need to do a trigger to do that. You just
need to make a cron job that run at whatever is an acceptable interval.
--
Keith C. Perry, MS E.E.
Director of Networks Applications
VCSN, Inc.
http://vcsn.com
This email account is being host by:
VCSN, Inc : http
45 matches
Mail list logo