Hi all
I cannot find any documentation on the space taken by a double precision
array. And the few tests I did surprise me.
Here are a few tries I did to understand
select pg_column_size(1.1::double precision) return 8--- as
expected
select pg_column_size('{}'::double precision[
Francisco Olarte wrote
> Hi Greg:
>
> On Fri, Jun 12, 2015 at 4:08 PM, greg <
> gregory.jevardat@
> > wrote:
>> I cannot find any documentation on the space taken by a double precision
>> array. And the few tests I did surprise me.
>>
>> Here
I'm trying to port an MS statement that's a bit involved with
timestamps, and I don't see anything in the docs to lead me forward.
It's basically a select statement, looking for records with a timestamp
within a certain range, where that range is calculated with one of the
fields. The WHERE cla
matically. Any pointers on where to look?
Thanks,
Greg
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
> Original Message
> Subject: Re: [GENERAL] SQLConnect failure
> From: Bill Moran <[EMAIL PROTECTED]>
> Date: Mon, April 02, 2007 2:54 pm
> To: [EMAIL PROTECTED]
> Cc: pgsql-general@postgresql.org
>
> In response to [EMAIL PROTECTED]:
>
> > We have code that has been using MSD
Greg
?
-Original Message-
From: Harald Armin Massa [mailto:[EMAIL PROTECTED]
Sent: 22 May 2006 04:51 PM
To: Greg
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Installing PostGreSQL automatically
Greg,
http://pginstaller.projects.postgresql.org/silent.html
read on there.
best wishes,
Harald
: Harald Armin Massa [mailto:[EMAIL PROTECTED]
Sent: 23 May 2006 08:43 AM
To: Greg
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Installing PostGreSQL automatically
Greg,
all the registry-entries are for "convenience", that is: to make it
possible for the installer to check if Pos
I am creating a Windows Forms App that uses PGSQL 8.1.4 for
the database. The database will be installed on the client, and the server.
I will only need to keep a few tables, not the whole
database synchronised. Is it better to manage this with my app?, or does PGSQL
support some decent sy
006 08:43 AM
To: Greg
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Installing PostGreSQL automatically
Greg,
all the registry-entries are for "convenience", that is: to make it possible
for the installer to check if PostgreSQL is installed.
So to use PostgreSQL on Win32, si
I am creating an email client that will contain email
messages. Now a message may have multiple large attachments.
1.)
Would the best way to store these large objects be in
an oid field?
2.)
I assume for performance reasons I should place these
large objects in a separate table
NALLAUNCH=1 ADDLOCAL=server,psql,docs
SERVICEDOMAIN="%COMPUTERNAME%" SERVICEPASSWORD="SecretWindowsPassword123"
SUPERPASSWORD="VerySecret" BASEDIR="c:\postgres"
-Original Message-
From: Harald Armin Massa [mailto:[EMAIL PROTECTED]
Sent: 05 June 2006 02
stalled on numerous
machines. So what do I put for the username and password values in the
command prompt?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Magnus Hagander
Sent: 05 June 2006 03:30 PM
To: Greg; pgsql-general@postgresql.org
Subject: Re: [GENERAL]
Our software will be using PostGreSQL as a database. Now I was wondering, if
the database is installed on lets say an entry level Celeron, with 256MB of
Ram, will it slow down the PC at all?
I'm not taking any queries into account here, just generally, does
installing the database slow down ones
I cannot figure this out… I am trying to do a silent
install.
Here is my command
msiexec /i postgresql-8.1-int.msi /qb /log install.log
INTERNALLAUNCH=1 ADDLOCAL=server,psql SERVICEDOMAIN="%COMPUTERNAME%"
SERVICEPASSWORD="SecretWindowsPassword123"
SUPERPASSWORD="VerySecret" BASEDIR=
My software package will install PostGreSQL on the server,
and clients will connect to it with a windows smart client application. What
would be the best way to keep the PostGreSQL usernames and passwords secure?
I will be doing a silent install of the database, and
obviously this will
think a direct connection to the database port using SSL
will be suitable for this kind of scenario?
From: Harald
Armin Massa [mailto:[EMAIL PROTECTED]
Sent: 12 June 2006 11:24 AM
To: Greg
Subject: Re: [GENERAL] Best security practices for installing pgSQL with
my software
Hello Greg
Well, then what do I need to get NpGSQL connecting to my server with SSL?
Do I just turn SSL on in the database and in my connection string set SSL to
true?
The other provider is CoreLab .NET for PostGreSQL. It seems pretty good, but
don't see the point in
paying for a provider when I can get o
ny suggestions as to what I may be
doing wrong? (Or how can I do it better?)
This is with postgresql 7.3.4
Many thanks,
-Greg
--
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
not fit into -MM-DD.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200306191110
-BEGIN PGP SIGNATURE-
Comment: http://www.turnstep.com/pgp.html
iD8DBQE+8dMSvJuQZxSWSsgRAiaYAKDrZMWBy7pv81BjCeSzMdbyTsu3eQCg9exM
vXj4GEQRhckbz2ygBmkX8z4=
=Wta
oice's cartid (which is
> a random number) is already entered into the system,
If "cartid" is a random number, 'ORDER BY cartid ASC' is not going to do you any good.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200306261048
-BEGIN
('mmlog_seq'));
Voila! A self-limiting table: INSERTING is not allowed, and the oldest record
is always overwritten. Remember to vacuum of course. And ORDER BY on the
ctime field to keep things in the proper order.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200307
r than 1, increment other than +1, or are at
their max_value.
The function you provided should work fine as well, although it should
return BIGINT, not int4. If you are doing this check often, you might want
to also have a function that returns all the sequences for you when called.
- --
Gre
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
As much as I would love to stay involved in this topic, I am leaving
for vacation tomorrow and my email will be erratic at best. Looking
forward to testing out 7.4 when I get back! :)
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8
for "enterprise" computing
Integrating PostgreSQL with PHP
Handling large objects
Others?
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200309241729
-BEGIN PGP SIGNATURE-
Comment: http://www.turnstep.com/pgp.html
iD8DBQE/cg0IvJuQZxSWSsgRAlFqAKCctDykbIr
I also have troubles with pg_dump. I have a database called 'shipping' and
it has many tables(I populated them via a script). To dump the database I
did these steps:
su greg and then pg_dump > /tmp/greg.dmp. A file greg.dmp gets created but
it has nothing in it(0 bytes). Could you ad
postgresql-docs-7.4.tar.gz
5b1aaf187cdd318063c19a309b63e83d9418262c postgresql-opt-7.4.tar.gz
460eca50bf5ce9a64aa9f46f5197bb52854b4fb5 postgresql-test-7.4.tar.gz
In addition, the 7.4 version is being distributed by BitTorrent:
http://bt.postgresql.org/
- --
Greg Sabino Mullane [EMAIL
ing to do, it is hard to say
which approach would be best, but in general, use ctid if you can,
use a sequence (or the application) if you just need numbering,
use a SERIAL for everything else, and use oids for quick unimportant
queries.
- --
Greg Sabino Mull
copyright notices exists anywhere (not entirely
true, but we'll skip over that), and thus the copyright really does belong
to the PGDG unless people state otherwise. (Of course, the PGDG is not a
real entity...)
I hope that the BSD people will reconsider their move and put PostgreSQL
bac
How to read system variables like datestyle, client_encoding via
ODBC...?
Can I use SELECT clause to do this...?
--Greg--
Hi
I have patched 6.5.1 to 6.5.2 and when I enter to psql... he notices me:
Urecognized variable client_encoding...
How to get rid of this problem...?
--Greg--
> > > Chai
> >
> > 17681: oid (object ID) of the inserted row
> > 1: number of rows inserted.
> >
>
>
> Why does it start from 17681?
> This is a fresh new table, shouldn't it start from 1?
>
Because another records in pg_... tables have a oid numbers...
--Greg--
On Thu, 14 Oct 1999, Chairudin Sentosa Harjo wrote:
> Dear all,
>
> mydb=> create table rtext (rtext varchar(10));
> CREATE
> mydb=> insert into rtext values ('hello');
> INSERT 17681 1
>
> What do "17681" and "1" mean?
>
> Could someone help me to understand this please?
>
"17681": nu
How can I read oid field from any table in trigger function...
When I try to read oid... postgres says ... record old has no field oid
Is this posible to read oid field from trigger function...?
--Greg--
seExplorer the first query works fine
please help....
--Greg--
LEFT JOIN ts3 USING (user_id)
GROUP BY 1;
ERROR: COALESCE types integer and ts2 cannot be matched
*LINE 3: SELECT COALESCE(ts1.user_id, ts2,user_id, ts3.user_id) AS us...*
* ^*
All types match from start to finish.
Thanks,
-Greg
Color me embarrassed. Must have been the lack of coffee.
Thanks to all who responded!
-Greg
On Fri, Apr 24, 2015 at 7:09 AM,
wrote:
> You probably mean ts2.user_id not ts2, user_id, right?
>
>
>
> Best regards
>
> Holger Friedrich
>
>
>
> *From:* pgsql-gen
``
My question is: is it possible to make `similarity` use the index? If not,
is there a way to speed up the query above?
Best regards
--
Greg Navis
I help tech companies to scale Heroku-hosted Rails apps.
Free, biweekly scalability newsletter for SaaS CEOs
<http://www.gregnavis.com/newsletter/>
rants).
My question is: is there a better way?
Best regards
--
Greg Navis
I help tech companies to scale Heroku-hosted Rails apps.
Free, biweekly scalability newsletter for SaaS CEOs
<http://www.gregnavis.com/newsletter/>
te:
> Hello.
>
> As I know 'lhs % rhs' is equivalent to 'similarity(lhs, rhs) >=
> show_limit()'.
>
> And so your query should looks like this:
>
> SELECT * FROM restaurants WHERE city % 'warsw';
>
> And it should use index.
>
&
a
per-query basis. I might be able to block some time to contribute.
Best regards
--
Greg Navis
I help tech companies to scale Heroku-hosted Rails apps.
Free, biweekly scalability newsletter for SaaS CEOs
<http://www.gregnavis.com/newsletter/>
correct. If it is, I'd appreciate a
high-level overview of what needs to be done. I can block a few hours to
work on this in the upcoming weeks.
Best regards
--
Greg Navis
I help tech companies to scale Heroku-hosted Rails apps.
Free, biweekly scalability newsletter for SaaS CEOs
<
Thanks for the replies.
On Sat, Jun 4, 2016 at 8:48 PM, Jeff Janes wrote:
> On Sat, Jun 4, 2016 at 2:50 AM, Greg Navis wrote:
> > Thanks for your replies.
> >
> > Sorry for confusion. Instead of `similarity(lhs, rhs) >= show_limit()`,
> > which of course is compl
FUNCTION6 gtrgm_picksplit (internal, internal),
FUNCTION7 gtrgm_same (gtrgm, gtrgm, internal),
STORAGE gtrgm;
Should my operator class mimic the one above?
--
Greg Navis
I help tech companies to scale Heroku-hosted Rails apps.
Fre
ons:
1a. Is it possible to make `gtrgm_consistent` accept `text` or
`pg_trgm_match` as the second argument?
1b. What's the equivalent of `match.match` and `match.threshold` (where
`match` is a `pg_trgm_match`) in C?
2. What to do with `gtrgm_distance`?
Thanks for help.
--
Greg Navis
I help t
"res = (*(int *) &tmpsml == *(int *) &nlimit
|| tmpsml > nlimit);" with "res = (tmpsml >= nlimit);" to fix the bug on my
machine. I'm not sure whether that's the long-term fix we want to have.
It's just there to help me make progress with trigrams.
evoke all privileges on the public schema to, yet
that user is still able to create tables in the public schema. Revokes
on other schemas work as expected, it seems the public schema is
treated specially.
https://gist.github.com/gfodor/c360683f25f55497c8c657255fd0e0f8
Any help appreciated!
eges granted to user on an object and why, or another
where you simply submit a statement to the DB and it gives you an
audit trail of why that statement is permitted (EXPLAIN PRIVILEGES?
:))
Thanks for the info!
On Tue, Sep 6, 2016 at 11:07 AM, Tom Lane wrote:
> Greg Fodor writes:
>> Ap
In the Ruby land there's a gem called faker
<https://github.com/stympy/faker> that allows you to generate fake data.
However, I'm not sure it can generate data based on a schema so a little
bit of scripting my be necessary. Would this approach work for you?
Yours
Greg
seen Navicat
advertised a few places which I was considering purchasing, and also
checked out the list at the postgres wiki -
https://wiki.postgresql.org/wiki/GUI_Database_Design_Tools
I am curious if anyone has any experience using one
Thanks,
Greg
Hi,
Is it easily possible to supply and receive tsrange types in epoch values, or
is it really all down always to string parsing?
As a general rule, I pass time in the app in epoch-float values, which is then
converted by the presenter/controller layer to the right format used by views,
wheth
I am using createdb to automatically create a database from a .sql file, but
in Vista it seems to prompt me for the postgres password.
How can I stop this from happening? I'm not using the -W or -password option
so why does it ask me for a password?
Here is my command...
createdb.exe -U po
b.exe prompting for password on Vista
On Sun, May 27, 2007 at 09:02:56PM +0200, Greg Quinn wrote:
> I am using createdb to automatically create a database from a .sql file,
but
> in Vista it seems to prompt me for the postgres password.
>
> How can I stop this from happening? I'm not usi
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Andrew Sullivan
Sent: 28 May 2007 07:46 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] createdb.exe prompting for password on Vista
On Mon, May 28, 2007 at 07:18:47PM +0200, Greg Quinn wrote:
&
a loop that will generate WAL
activity, run that until the segment gets archived. Haven't really
thought of something good to use for that purpose yet.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)
e the first part of the series
(from the base backup), the last ones (from the current pg_xlog), but will
be missing some number in the middle (the recycled files).
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 6: explain analyze is your friend
hat goes into the WAL when you do that. You'd need to
implement a process that made sure to sync changes in the underlying
filesystem before modifying a tablespace.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast
the xlog directory and instead
only work with what the archive_command is told.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
cho
me to be sent a ticket.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's
nderstand that if your underlying hardware has issues, that may cause
more corruption (with possible data loss) rather than less.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
wing the recommended procedure rather than trying to do
something a little different. There are too many edge cases here that
could^H^H^H^H^Hwill bite you one day.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)-
ve this month's average", you'll be in a
positition to catch performance issues before they completely blindside
you; makes you look good in meetings, too.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)
ey're doing simply
by using more expensive hardware. In your case, I think it's safe to say
you've got quite a bit of margin for improvement that way when you run
into a problem.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
delete any archived logs file on the secondary from
before that time. Instead of doing "ls | sort -g -r" you should be doing
something like looping over the files in a bash shell script and using
[ -ot ] to determine which files to delete.
--
* Greg Smith [EMAIL PROTECTED] htt
s.fnal.gov/dsg/external/freeware/mysql-vs-pgsql.html I refer
to sometimes. It's from March of 2005 so several pieces are out of date.
Kevin Kline's "SQL in a Nutshell" also has some helpful suggestions on
syntax differences between the major SQL dialects, but it's e
or: There is a time difference
between the Client and Server." when trying to login.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your d
be given
their own port number.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
h cluster you
get to.
You'd need to give some more OS and general network setup information to
get any more specific or clever than that.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
wary of when trying this is the SQLite deals with
dates and times very differently than PostgreSQL does. Even when
insulated with an ORM tool that can bite you.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast
ion of the PITR mechanism or its
cleanup.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joinin
o simulate types and operations that now are
built-in to PostgreSQL, like the interval type, so it's not quite as
intimidating a read as it seems at first; there's a lot of code for older
databases that you can completely ignore.
--
* Greg Smith [EMAIL PROTECTED] http://w
iable writes that use the drive's cache
for instant fsyncs, instead of right now where you have to push all that
to the controller level.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 9: I
westnet.com/~gsmith/content/postgresql/pg-disktesting.htm has
an outline of how to do those tests.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
hat label in it.
That's how you prevent this class of problem. If you don't find the label
you expect in the history, abort the whole thing because your backup
didn't happen correctly.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
--
mmend http://www.gtsm.com/oscon2003/toc.html on this topic.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
e for this parameter for
your class of system.
effective_cache_size = 650MB
This is in the right ballpark, but you might see improvements increasing
to the 1GB range. See
http://www.westnet.com/~gsmith/content/postgresql/pg-5minute.htm for more
on this and related topics.
--
* Gre
h multiple anecdotal
samples on this subject:
http://reviews.pricegrabber.com/hard-drives/m/11165851/
The problems with their products are so widespread I'm sure it would be
easy for you to find many more if you search around a bit.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.co
f things you'll need to learn.
Gentoo can be a good server environment, but the learning curve to get
started is probably harder than you want to take on if you're new to
Linux.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---
n a 64 bit installation is not
a problem limited to Ubuntu; it's an equally messy problem on all Linux
distributions, and the workarounds for each are similar. On the topic of
Firefox plug-ins:
Fedora/RHEL:
http://www.cyberciti.biz/tips/linux-flash-java-realplayer-under-64bit-firefox.html
Plucker ( http://plkr.org/ ) is a tool for viewing documentation on
handhelds running the PalmOS, and I just noticed that they have the
PostgreSQL documentation available:
http://projects.plkr.org/postgresql-documentation/
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore
k for dead horse riding[1], obviously technique #12
"Harnessing several dead horses together for increased speed" would allow
faster progress were all these addressed at once.
[1] http://soli.inav.net/~catalyst/Humor/dhorse.htm
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmi
stamps on all that data.
To get more specific advice, report if you see anything interesting in
your log files and send some details about the PostgreSQL version you're
using and the settings in the postgresql.conf file that you've changed
from their defaults.
--
* Greg Smith [EMAIL PR
code coming in 8.3 that addresses this issue head-on, it can be tricky to
accomplish in the current production releases.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 9: In versions below 8.0
GROUP BY c.relname,isdirty
ORDER BY 2 DESC;
I have something I'm working on that covers a lot of this topic at
http://developer.postgresql.org/index.php/Buffer_Cache%2C_Checkpoints%2C_and_the_BGW
but that's probably a little too low-level for you to chew on usefully
right no
some disclaimers
about what you should ignore in the guides that haven't been updated
recently.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 3: Have you checked our extensiv
setting either percentage
over 5% or either maxpages>100 as a first step on a production system.
You may be in for a bad day tomorrow.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 6: expla
On Mon, 13 Aug 2007, Scott Marlowe wrote:
We can look at how big your shared_buffers are, your work_mem, and a
few others in postgresql.conf.
That's going to be sort_mem, not work_mem, with 7.4
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimor
yes
QED.
It's a strong point in PostgreSQL's favor that it behaves in what I
regard as a sane manner. That Oracle stuff makes me shudder -- it's unclean.
Greg Williamson
Senior DBA
GlobeXplorer LLC, a DigitalGlobe company
Confidentiality Notice: This e-mail message, incl
ng of trivia
in that category lately, haven't gotten to issues with their product much
so far.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore y
caching behavior not being
turned on by default in that operating system.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
relatively small amount of memory. The main benefit for having a
caching controller is fsync acceleration, the reads should pass right
through the controller's cache and then stay in system RAM afterwards if
they're needed again.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com
stem, your card, or the OS/driver you're using
if open_sync doesn't work under Linux; in fact, it should be faster in
practice even if it looks a little slower on test_fsync.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end o
happens to the pending writes for the drives that aren't there
anymore is kind of undefined though; presumably they'll just be thrown
away, I don't know if there are any cards that try to hang on to them in
case the original disks are connected later.
--
* Gr
data from the
beginning. That's another reason why the Wiki is a bad way to cope with
this data; adding another column is a painful and error-prone operation.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of
been reasonable to maintain
because more rows get added, but rarely columns. This feature comparision
table will be the other way around, which is the harder one to cope with.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)
to suggest that the Postgres vs. PostgreSQL renaming
argument be dropped in favor of renaming the database "Horizontica".
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 6: explain analyze is your friend
gives you considerably more flexibility than trying
to squeeze everything into the archive_command.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
ut giving
some specifics about the two disk controllers you're comparing, how much
cache they have, and whether they include a battery backup.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
--even though it's possible the real-world performance
of the CPU/memory might be a little better on the Opteron box. The fact
that it will have 2X as many disks will just increase its lead. And now
you know why everyone wanted such specific information!
--
* Greg Smith [EMAIL PROTECTE
1 - 100 of 1774 matches
Mail list logo
