restore_command example from the manual there,
which is really not a production quality solution there.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
a simple schema that follows the structure of the fields in pg_class
and pg_database needed and you're off. You may still get unnamed stuff
that's just not visible yet, the cross-database stuff was the source for
most of the missing bits I ran into.
--
* Greg Smith gsm...@gregsmith.com http
you're talking an extra bit of coding; pgpass support you
basically get for free in your app if it's talking to the database with
psql.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
involved has turned off fsync support as a performance
optimization.
There's a bunch of additional trivia in this area at
http://www.postgresql.org/docs/current/static/wal-reliability.html and my
article at
http://www.westnet.com/~gsmith/content/postgresql/TuningPGWAL.htm
--
* Greg Smith
complicated and way to easy to
screw it up in a way you won't notice until your data has already been
eaten.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
to the outside
world.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
can't really get just from the slides.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
$PGLOG
pg_ctl stop
For my login, I add these two bits as well to make that easier, since I
never use the real start/stop commands anyway:
alias start=pg_ctl -D $PGDATA -l $PGLOG -w start tail $PGLOG
alias stop=pg_ctl -D $PGDATA stop -m fast
--
* Greg Smith gsm...@gregsmith.com http
sorting out the bits
you're going to need but don't have yet.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
, but there's still plenty of rough spots to get nailed by.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
scanning and
execution platform keeps volume moving upward in lock step with what
hardware is capable of. The last mainstream news article on this topic
was http://www.nytimes.com/2009/07/24/business/24trading.html
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent
happening too.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
a
database server on the same system as the browser) is tiny.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to the size limits documented at
http://www.postgresql.org/about/ , so you probably having nothing to worry
about here.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
at least I stay clean.
The TuningWizard software redirects you over to
http://forums.enterprisedb.com for support with it and that's really the
right place to ask questions about that specific program.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql
whether they were intending to release the
DynaTune program and didn't get the impression that was forthcoming, and
it's unreasonable to ask them to, so I don't know what further questions
you might ask them.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via
of 8.3 from in order to put back libpq.so.4.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Tue, 28 Jul 2009, mukeshp wrote:
Can anyone suggest me tools for monitoring postgresql server. ?
An idea what operating system you're running the server on would help
here.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing
.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
/0646
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
database at Yahoo:
http://it.toolbox.com/blogs/database-soup/2-petabyte-postgresql-24848
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
an
issue in your app rather than on the server side of things.
P.S. Posting the same question to two lists here is frowned upon;
pgsql-general is the right one for a question like this.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing
.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ever wanted to know at
http://www.westnet.com/~gsmith/content/postgresql/chkp-bgw-83.htm if you
haven't seen that already.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
eventually you'll reach a point where there are
none of them happening during some test runs.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
. All this poker
talk is bad, I've been staying away from the tables for a while now but
fear this topic is going to pull me back again--just to see how the
database apps have matured, of course.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general
.
Agreed, it doesn't seem like a likely cause. If the problem reduces in
magnitude in proportion with the size of the buffer cache, we might have
to accept that's it's true regardless; that's why I was curious to see
what impact that had on the test results.
--
* Greg Smith gsm...@gregsmith.com
of software
are pretty tightly constrained:
http://www.mysql.com/about/legal/licensing/foss-exception/
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
the older, known bad logic here. See
http://www.solarisinternals.com/wiki/index.php/ZFS_Evil_Tuning_Guide#Device-Level_Prefetching
and http://bugs.opensolaris.org/bugdatabase/view_bug.do?bug_id=6437054 for
details.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
you'll need to edit in order to change this
situation.
If you still can't resolve your problem, you should ask about it on the
pgpool-general mailing list rather than this one:
http://lists.pgfoundry.org/pipermail/pgpool-general/
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com
at
http://www.justatheory.com/computers/databases/postgresql/benchmarking_functions.html
which can help you run stuff multiple times even.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
On Tue, 23 Jun 2009, Ray Stell wrote:
What is the entry point for source and config documentation of the standby
patch?
http://wiki.postgresql.org/wiki/Hot_Standby
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql
time in
this thread...
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
that early enough in the design process to properly plan for
it.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
-partitioning-database-tables-explain-your-queries/
In that order really; those go from general commentary down to focusing on
specific issues people tend to run into.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general
in the first place. The usual way
tables get unclustered involves random insertion and deletion, and that
just doesn't happen for data that's being imported daily and never deleted
afterwards; it's naturally clustered quite well.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
system
design for some goals. You just have to recognize that the volumes are
statistically pretty fragile compared to a traditional RAID configuration
on dedicated hardware and plan accordingly.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql
On Tue, 16 Jun 2009, Michelle Konzack wrote:
Am 2009-06-16 12:13:20, schrieb Greg Smith:
you'll be hard pressed to keep up with 250GB/day unless you write a
custom data loader that keeps multiple cores
AFAIK he was talking about 250 GByte/month which are around 8 GByte a
day or 300 MByte
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
://www.postgresql.org/docs/8.3/static/functions-info.html as well.
(The pg_toast filter is probably redundant here, I try to keep that in all
these pg_class/pg_namespace join examples because it's handy for more
normal queries)
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent
is a subtle problem that doesn't sneak up on you until
you've been in production a while.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
point where a checkpoint will note
the files aren't needed anymore, and at that point they'll be recycled
(renamed with a new id and used again) or deleted. You can't change the
files until then though, and that time can be several minutes after
archive_command is called.
--
* Greg Smith gsm
periodically for
sites that can't or won't install rsync for the job instead (always some
variant on for security reasons). Unfortunately those sites also don't
like releasing the resulting code to the world at large, so I don't have a
full sample to show you.
--
* Greg Smith gsm...@gregsmith.com
decoupled from what choices you make for that layer. Focus on writing
scripts to atomically copy the files into the right destination on the
standbys, and pg_standby will take care of applying the shipped log files
to the database.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com
. See page 13 of
the presentation for
http://blogs.sun.com/jkshah/entry/effects_of_flash_ssd_on for his quick
note on that topic.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
it to -general rather than cc'ing multiple ones.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Wed, 27 May 2009, Kevin Kempter wrote:
I'm looking for suggestions per good ERD tools (Linux based preferred).
There's a giant list that includes lots of ERD tools at
http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools
--
* Greg Smith gsm...@gregsmith.com http
maintenance use when I did a quick check of its results
before, but those were tables without variable widths, TOAST, etc. This
is one of those boring tasks that DBAs really want more
monitoring-friendly visibility into.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore
needed.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
on AV in the FAQ:
http://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Native_Windows#What_Anti-Virus_software_is_compatible.3F
with a note referring to that in the install section above it where this
info used to live.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com
certainly find situations where sync writes end up working out
better, but they're not common.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
, as a different type of report.
Accordingly, I just updated with examples of both types, as well as
something to work against pre-8.1 databases.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
rotation is needed to give you breakpoints to import at
though.
The other common idiom here to detect changes is to save the output from
pgdump -s regularly and look for changes via diff.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general
://jasperforge.org/plugins/project/project_home.php?group_id=102
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
is remotely accessible from all of its interfaces, and
then you can do all filtering of who can connect just via pg_hba.conf
instead. See
http://www.postgresql.org/docs/8.3/static/auth-pg-hba-conf.html for more
information.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
in various
ways to play with.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ideas for features you might find useful in the newer version.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
/ is a good place to find PostgreSQL
oriented blogs at.
I've been collecting 8.4 related blog and talk presentations onto a list
at http://wiki.postgresql.org/wiki/Waiting_for_8.4 and encourage others to
expand on that with ones I've missed.
--
* Greg Smith gsm...@gregsmith.com http
there you can
make a fairly accurate guess of what the whole dump is going to take up,
presuming your data is fairly evenly distributed such that the first
records that come back are typical of the whole thing.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via
to hard problems most people never even think they
need to solve, until they get bit by one.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
a lot of people out.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
possible segment backlog so you can never get this
far behind
2) Increase the rate at which random I/O can be flushed to disk by either
a) Improving things with a [better] battery-backed controller disk cache
b) Stripe across more disks
--
* Greg Smith gsm...@gregsmith.com http
.
Yeah, EBS is not exactly a high-performance or predictable database
storage solution, particularly when you get to where you're calling fsync
a lot--which is exactly what is happening during the period you note your
system is frozen.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com
controller with a write cache involved, that narrows the
gap between SDD and regular drives quite a bit.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
/Tuning_Your_PostgreSQL_Server
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
clear in the tuning guide on the
wiki, I'll do an update to improve those sections when I get a minute.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
development stages is to create a
seperate disk partition for the temporary tables, turn that into a
tablespace, and then use temp_tablespaces to point the temp tables toward
it. The idea is to separate out I/O to the temp tables so that you can
measure it to see how significant it is.
--
* Greg Smith
than dropping into Perl.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
. That should give you a better idea
what's going on here, and if the badness shows up there it will be much
easier to get someone at IBM to pay attention too.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general
vendors seem completely incompetant at producing out of the
box tunings that work well for database use (I feel a RAID5 rant brewing).
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
at
http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_MySQL:_Comparing_Reliability_and_Speed_in_2007#Sun_Microsystems_2007_jAppServer2004_Benchmark_Results
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general
, the parameters that controls this behavior are described
starting at
http://dev.mysql.com/doc/refman/5.1/en/innodb-parameters.html#sysvar_innodb_flush_log_at_trx_commit
For something with lots of disk commits, it's critical that you have both
systems configured identically here.
--
* Greg Smith gsm
the only UNIX{-ish} OS where the default is a genuine sync
write Solaris.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
-
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
dormant so far.
I leave it as an exercise to the dedicated reader to modify the sysbench
test to use O_SYNC/O_DIRECT in order to re-test LVM for the situation if
you changed wal_sync_method=open_sync , how to do that is mentioned
briefly at http://sysbench.sourceforge.net/docs/
--
* Greg Smith
is that in order for this to bite you,
I think you'd need to have another, incorrectly ordered write somewhere
else that could happen before the delayed write. Not sure where that
might be possible in the PostgreSQL WAL implementation yet.
--
* Greg Smith gsm...@gregsmith.com http
this
category of journal mayhem not so much of a problem. But when I read
about fsync doing unexpected things, that gets me more concerned.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
-
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
on the screen it should narrow
the possibilities here.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
-
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-I lets you check if write caching is on, hdparm -W lets you toggle
it off. That's for ATA disks; SCSI ones can use sdparm instead, but
usually it's something you can adjust more permanently in the card
configuration or BIOS instead for those.
--
* Greg Smith gsm...@gregsmith.com http
On Fri, 6 Mar 2009, Ben Chobot wrote:
How does turning off write caching on the disk stop the problem with LVM?
It doesn't. Linux LVM is awful and broken, I was just suggesting more
details on what you still need to check even when it's not involved.
--
* Greg Smith gsm...@gregsmith.com
it.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
/cookbook/
Even though that is mainly aimed at older versions, there are a lot of
neat PL/PGSQL examples there that you might wrangle into working against a
current one.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql
AS kb FROM pg_class;
But that might have been 8.0.
There is an example of a script like you describe on starting on P88 of
Bruce's presentation at
http://momjian.us/main/writings/pgsql/administration.pdf
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via
parameters in that class) because the parameter changes a shared memory
allocation, which is only done at startup.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
someone have ranted about RAID-5 by this point in the thread?
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
than asking the kernel to drop its caches?
fillmem/flushdisk also work with kernels before 2.6.16, which means that
it's not avaialble on still common platforms (RHEL4 for example). If
you've got drop_caches, it's the better approach, that pages gives an
answer if you don't too.
--
* Greg
use contrib/pg_buffercache to confirm the
function is doing what you expect.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
will save the
rows that are rejected for some reason, which is usually what happens when
there's a delimiter issue. You can then edit those by hand to work around
random odd delimiter problems.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql
.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
for the occasional
time this pops up.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
of that topic, figuring out which indexes you
don't need.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
already but could be smarter, it
includes some parameters that aren't there in 8.2, and doesn't work at all
on 8.1 or earlier.
If you step outside of just free solutions, Enterprise DB's commercial
server product does more complicated autotuning via their DynaTune
feature.
--
* Greg Smith gsm
On Sat, 31 Jan 2009, Adam Rich wrote:
- lack of queryable high-water marks useful for tuning
What specific things would you consider important to track a high-water
mark for that aren't already there?
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via
as you can simulate.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
have open issues,
I'd be curious to get your feedback about that piece.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
is that as it is right now, it's also hard to answer the
question how close am I to having this plan fail? until it already has.
I know there's been some academic work in this area as part of classes on
database internals, I'd like to see some of that turn into a production
feature.
--
* Greg Smith gsm
to concurrency.
There were two Varlena postings on this and one other good article. I got
sick of not being to find them every time I wanted to and added links to
them all at http://wiki.postgresql.org/wiki/Slow_Counting
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
would be doing better right now had they not decided to light
$1B on fire back in January, that's where their stock really accelerated
its dive downward.
RedHat is actually by far in the best financial shape of the three, at
least they make more money than they spend.
--
* Greg Smith [EMAIL
else may be able to point you toward better estimating how far
it's got left to go, I haven't ever been stuck in your position for long
enough before to figure that out myself. Good luck.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing
. As a general aside, if you ever find yourself in this position
again, where you've got an urgent database problem, something you might do
in parallel with posting here is trying the IRC channel:
http://wiki.postgresql.org/wiki/IRC2RWNames
--
* Greg Smith [EMAIL PROTECTED] http
focusing on any individual kernel version long enough to squash its bugs
right anymore; those will all get fixed in the next version, right?
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
401 - 500 of 758 matches
Mail list logo