that could corrupt data. Even if it were
feasible for you to self-certify in some fashion, the only path there that
would make sense would be extracting the changes made to reach EAL1 in
that customized 8.1.5, then apply at least those important patches.
--
* Greg Smith [EMAIL PROTECTED] http
that.
Does Linux suck compared to BSD?
Not the Mac OS BSD. Last time I looked into this OS X was still
dramatically slower than Linux on things like process creation.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast
application, you'll have
to go through a dump, initdb with the change, then reload on your
database.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 4: Have you searched our list archives
never have too many ways to try and recover from such
a situation.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
-ish, you're probably linking
against unixODBC, which is available under the LGPL presumably to avoid
this issue.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 4: Have you searched our list
for clues.
--
* 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 datatypes do
through either of
those is that you end up with some baseline idea of what someone who has
gone through the class/test has been exposed to.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 9
in
that area from day one. Can you build a database without someone who has
been through these experiences? Sure. That doesn't mean it's a good
idea.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 1
, focusing on the raw performance of PostgreSQL is kind of
misleading. You shouldn't have to hit the database for everything if you
put the right kind of layer on top.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast
spitting out the duplicate key error isn't the problem; that one
has the right syntax. The problem here is whatever is doing that initial
population of 1-37 in the table without using the sequence number.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
your copy during that period.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
normally recommend, but with his particular system that worked
out well.
--
* 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
,
and that the background writer waiting for that big write to finish might
delay checkpoint requests from processing in a timely fashion.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 5
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)---
TIP 6: explain analyze is your
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 PROTECTED] http://www.gregsmith.com Baltimore, MD
it to be.
--
* 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 datatypes do
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
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
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)---
TIP 3: Have you checked our extensive FAQ
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.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
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 broadcast
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/
a 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 Baltimore
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 of broadcast)---
TIP 6: explain analyze is your
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 your desire
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 Baltimore, MD
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 now.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast
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 extensive FAQ
percentage
over 5% or either maxpages100 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: explain analyze is your
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.gregsmith.com Baltimore, MD
.
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 PROTECTED] http://www.gregsmith.com
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, the planner will ignore your desire
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
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
---(end of broadcast
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
Ubuntu: http://ubuntuforums.org/showthread.php?p=1174435
--
* Greg
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.com Baltimore, MD
://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/
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.
--
* Greg Smith [EMAIL PROTECTED] http
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
---(end of broadcast
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
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: In versions
to be 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
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 joining column's
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://www.gregsmith.com Baltimore, MD
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 first xlog in base backup ] to determine which files to delete.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com
/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 even older.
--
* Greg Smith [EMAIL
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 desire to
choose an index scan if your joining column's
to 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/
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
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)---
TIP 3: Have you checked our extensive FAQ
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
---(end of broadcast
, 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
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)---
TIP 1
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 datatypes
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)---
TIP 3: Have you checked our extensive FAQ
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
choose an index scan if your joining column's datatypes do
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
, 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)---
TIP 1: if posting/reading through
701 - 758 of 758 matches
Mail list logo
