sts with bonnie++ to make sure the array is performing as
expecting.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
" at
http://www.westnet.com/~gsmith/content/postgresql/ if you want to know
exactly how this is all implemented.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent via pgsql-general mailing list (pgsql-
ce which as i recall was a *16* bit
interface. I'm not sure what exactly that means but as a result the
32-bit odbc configuration is entirely separate from the "regular" odbc
configuration. It's not the instruction set that the dll uses it's
which set of shared data struct
on by default, which unfortunately happens to
be much slower operation by default too.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make ch
y inactive. I expect SQL/MED plans for the next release may
get fleshed out at this year's developer's meeting in a couple of
months, should have a better idea who might be working on this by the
end of May.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Se
bad on benchmarks if the
writer doesn't understand how database commits to disk work--which seems
to the case at Phoronix. They really are not running the right sort of
PostgreSQL benchmarks at all over there.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Trainin
the entire snapshot
which might be able to bring the performance up to the same level and
hopefully allocate all the blocks sequentially.
--
greg
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
using something like sysbench first[1], and if those
numbers come back higher than disk RPM rate declare the combination
unusable for PostgreSQL purposes rather than reporting on the fake numbers.
[1]
http://www.westnet.com/~gsmith/content/postgresql/pg-benchmarking.pdf ,
page 26
--
Gr
ans to perl variables differently or Postgres
will change the text representation then you could alter the SQL to
say something like CASE WHEN has_schema_privilege() THEN 1 ELSE 0 END
or whatever constant you prefer like 'yes' and 'no' or 'ok' and ''.
--
. But 8.1 isn't capable of applying log files one at a
time; it applies whatever you've got, and then it's done with recovery
and transitions to live. You can't just stop the result and then feed
it the next file, as you've already discovered through experimentati
aybe it's worth
the trouble to model each possibility against your workload, with
accurate numbers to substitute into any such guess.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent via pgsql-general
me logging messages I can process?" is still quite open in my
mind. The idea Magnus was already suggesting here, to add an alternate
"pipe" destination, would be one useful step forward here.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g
e perspective of a database person. If
your image data has to be high performance, too, maybe an even 4/4 split
between OS+data and DB+xlog would make more sense for your app.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www
available: write-back
cache enabled when battery works, write-through [cache disabled] if doesn't.
Make sure you setup monitoring alerts via e-mail for drive and battery
failures too; test them out by yanking at drive before the server goes
into production if you can.
--
Greg
recommend them only because their performance used
to lag relative to some of the alternatives--they were more the
"reliable but a bit slower" choice in earlier times. This is no longer
the case.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Supp
Bruce Momjian wrote:
Greg Smith wrote:
Given what you've said about your budget here, I suspect that you're
heading toward either 3ware or LSI and all SATA drives. I wouldn't
expect that big of a performance difference between the two with only 8
drives on there. If you ha
e RAID-1 for the boot drive in particular is
more difficult to manage and recover from failures with.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent via pgsql-general mailing list (pgsql-general@postgresq
he keepalive handling on the server side. Did you mention your
PostgreSQL server version and platform? I didn't see the exact code
path you're stuck in during a quick look at the code involved (using a
snapshot of recent development), which makes me wonder if this isn'
d executes them in the same order
> and relative time against a PostgreSQL database cluster.
Do you have a multi-threaded model that tracks which transactions each
query belonged to and runs them concurrently like they were in the
original setup? That's what I've been looking for.
--
g
you
haven't seen it drop yet.
I'm assuming you don't have WAL shipping turned on by setting
archive_command. There can also be an excess of these segments that
can't be cleaned up if your archiving scheme fails.
--
Greg Smith 2ndQuadrant US Baltimore, MD
Pos
e and operating system
Szymon is using if you suspect this is the case. I keep hearing about
systems where this is slow, but despite claims that they're common I've
never actually seen one.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g
fail-over, just start shipping
from the new primary to that 3rd server, now the replacement standby,
and sync any files it doesn't have. Then switch it into recovery. Much
faster than doing a new base backup from the standby on larger systems.
--
Greg Smith 2ndQuadrant US Baltimore
e involved and the
fast write speed, it's certainly feasible to just flush at power loss
every time rather than what the BBWC products do--recover once power
comes back.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www
nly is a source of overhead on mostly idle systems.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
Bryan Murphy wrote:
On Fri, Mar 26, 2010 at 1:32 PM, Greg Smith <mailto:g...@2ndquadrant.com>> wrote:
If there's another server around, you can have your
archive_command on the master ship to two systems, then use the
second one as a way to jump-start this whole p
Vitali Xevet wrote:
How does Postgres handle concurrent write requests?
http://www.postgresql.org/docs/current/static/transaction-iso.html
describes how they're isolated and can potentially interact with one
another.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Tra
at the current limiter is.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
the myYearbook guys at this year's PG East last week, I
discovered that it (and their other tools such as staplr and golconde)
are now at http://github.com/myYearbook/ instead of the
area51.myyearbook.com site things used to be hosted at.
--
Greg Smith 2ndQuadrant US Baltimore, MD
Postg
people fill in the details – but didn’t see a
way to register...
No, just sign up for a community account as described on the main page
of the wiki.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent vi
I just summarized some of the discussion on this thread and created a
wiki page that starts to cover each of the three tools now available for
this job: http://wiki.postgresql.org/wiki/Statement_Playback
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g
hem anyway is their ruggedness under really bad failure conditions
that direct-attached storage can struggle with.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent via pgsql-general mailing list (pgsql-gener
eting any data on it you could do something like:
dd if=/dev/zero of=25205.2 bs=8192 seek=$(( 348938 - 2 * 128 *
1024)) count=1
--
greg
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
There was a major breaking change to how casting is handled in 8.3.
Some good reading about what happened:
http://www.depesz.com/index.php/2008/05/05/error-operator-does-not-exist-integer-text-how-to-fix-it/
http://petereisentraut.blogspot.com/2008/03/readding-implicit-casts-in-postgresql
ach work fine on their own,
but chain them together by making one run against a subquery of the
other and you can get mysteriously burned when things aren't equal the
way you expected.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadra
But there are zero
guarantees that will be the case, or that latency will be bounded at
all. Recommended practice is to carefully monitor how much latency lag
there is on the standby and trigger alerts if it exceed your expectations.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Tr
standby to receive the data into memory (AKA
semi-synchronous)
fsync: The standby must have committed the data to disk such that it
won't be lost in case of a crash (AKA synchronous)
apply: That data must actually be fully processed and available for
queries against the standby
--
Greg Smith
or later) to log when work_mem is being
exceeded and sorts are going to disk.
That's really it; the rest of the sort of data that's available in the
v$ views isn't exposed in nearly as much detail in PostgreSQL yet.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Traini
ghtforward patch to write with clear value, which we can
always use more of. I added it to
http://wiki.postgresql.org/wiki/Prioritised_Todo#psql so people looking
for an easy patch to chew on one day can find it.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Sup
mp;group_id=138&func=browse like
lack of support for JDK 1.6 and some known complier issues.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent via pgsql-general mailing list (pgsql-general@post
this problem once, rather than continuing to fight it a
little every single day forever.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
64 bit builds, and you seem to have run into a divergence between the two.
As for mailing lists, you can try
http://lists.pgfoundry.org/pipermail/pljava-dev/ for things specific to
building it.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2
On 18 Oct 2011, at 20:17, Tom Lane wrote:
> =?ISO-8859-1?Q?Fr=E9d=E9ric_Rejol?= writes:
>> I created a custom CAST to cast from one table type to another.
>> pg_dump does not include my custom CAST.
>
> Hmm. The reason for that is that the table types aren't considered
> dumpable objects. I s
-v product_feed_data_
COMMENT ON TABLE product_key IS 'A temporary table used to sync
product_feed_data.does_exist_in_product. ...
HTH,
Greg Williamson
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
get a better response on the lower volume pgsql-performance mailing list
too.
--
Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
t. And the earlier the better--since many migrations have a long
lead time, just knowing it's coming in the next version would be good
enough for some people who are blocked right now to start working on theirs.
--
Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD
Po
we'd have to validate whether query prioritization code was
operating as expected or not, I imagine some extra monitoring tools
really need to get built first. Might as well expose those for people
like yourself too, once they're built for that purpose.
--
Greg Smith 2ndQuadra
e
this sort of thing easier to build into the core database. For example,
the recent "Command Triggers" feature submission will make it easier to
catch DDL changes as well as queries for this sort of thing.
--
Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD
PostgreSQ
On 12/09/2011 08:54 PM, Greg Smith wrote:
I decided about a year ago that further work on using Systemtap was a
black hole: time goes in, nothing really usable on any production
server seems to come out.
My off-list e-mail this weekend has, quite rightly, pointed out that
this cheap shot is
e to be in the PostgreSQL core to
be packaged nicely so that you can easily install and use it. It's
probably easy for you to get pgAdmin installed and working for example,
and that's not a part of core. There's just been a lot more work put
into packaging it than most to
28.890 ops/sec
Non-Sync'ed 8kB writes:
write 112113.908 ops/sec
--
Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us
--
Sent via pgsql-general mailing list (pgsql-gener
Tom Lane's post from '06 about how 'sequences are
black boxes', but not much else turned up.
Surely I don't have to maintain a separate sequence fix-up script to
keep with my backups, do I?
Thanks.
--
Greg Donald
--
Sent via pgsql-general mailing list (pgsql-genera
alls in my SQL
file have a '1', like this:
SELECT pg_catalog.setval('company_id_seq', 1, false);
Some do not have a '1', some are actually set correctly.
Thanks.
--
Greg Donald
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make change
back this morning and pulled older backups, from when I was
using pg_dump that came with my PostgreSQL 8.4 install. Those backups
look fine to me, all the setval() calls are there and correct. So it
looks like a problem with the new pg_dump best I can tell.
--
Greg Donald
--
Sent via pgsql
id) FROM table_name);
to fix things up for me on my local setup.
--
Greg Donald
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
rticular bug report form.
I may try that version tonight, I actually found 9.1.2 packages
http://www.openscg.org/se/postgresql/packages.jsp
Maybe my fix will be in there.
--
Greg Donald
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
On Wed, Dec 28, 2011 at 1:00 PM, Tom Lane wrote:
> Greg Donald writes:
>>> Are you
>>> sure that the sequence is being used to insert those values into the
>>> table?
>
>> When I insert a new row into either of the tables I previously
>> described, t
On Wed, Dec 28, 2011 at 4:58 PM, Adrian Klaver wrote:
> What is the pg_dump command, with options, you are using?
My backup shell script contains:
/usr/bin/pg_dump cp | bzip2 > $FILE
--
Greg Donald
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chan
Wow.. so now I'm doing it wrong?
I'll pass, thanks for all your "help" guys. It's been a blast.
--
Greg Donald
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
sequences of the same names in different schemas.
I have one schema and one database on that one database server.
And like I said, it worked fine until 9.1. If it was any of those
reasons you suggest, would I not have experienced the same problem
back in 8.4? I would think so.
--
Greg Dona
anything.
Those grep calls prove my old backups with 8.4 pg_dump were good to go
and now they are not with 9.1 pg_dump.
> I remain unclear as to what state is actually in the
> database, or what is being dumped,
The whole thing is being dumped. One command /usr/bin/pg_dump cp,
that'
hich we poll )see the "Monitoring and Testing" section ... study their source
code some and see how they come up with lag times.
HTH,
Greg WiIliamson
DBA
Powerreviews dot com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
htt
NALYZE plans of whatever the
slowest single query is. More on that subject at
http://wiki.postgresql.org/wiki/Slow_Query_Questions
--
Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.com
--
Sent via pgsql-general
runtime.
I've had unpleasant experiences with commercial tools; CVS works well for
simple environments and git can be used for more tangled development work.
HTH,
Greg Williamson
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.
>
>Of course events destined to this table will be queued by Slony while the
>table is locked.
>
I've not much recent experience with Slony, but possibly pg_reorg, found at:
<http://pgfoundry.org/projects/reorg/>
would be of use ...
Greg Williamson
--
Sent vi
ellent conference. It's
also very well run by its organizers, even though they are "private
event management" by your definition.
--
Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.com
On 28 Mar 2012, at 07:44, Guillaume Lelarge wrote:
> On Tue, 2012-03-27 at 18:51 -0700, leaf_yxj wrote:
>> create one function to let other user execute vacuum command. got such an
>> error. Please help. Thanks. Regards . Grace
>>
>> rrp=> create function vacuum_f ( tablename char(100))
hing to consider. I'm not sure if
you'll really see the gains you're hoping for, but it should be easy
enough to test.
--
Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.com
--
Sent
Of course a
several year newer kernel runs much faster on latest generation hardware.
--
Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
The trim function needs to be told what sort of trim to do --
Following the 9.1 manual (you did not specify which version of postgres you are
using) try:
UPDATE mytable SET id = trim(both ' ' from id).
(untested)
See <http://www.postgresql.org/docs/9.1/static/functions-s
el is going under every single day. Nobody seem to care anymore about
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
g badly for "quite a few
years", but the only serious divergence from its competitors was only this
year. Sun 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
e hard
pressed to execute any manual recovery that's any safer or more efficient
than that is.
Someone 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. Go
ut
This isn't a real popular time of day for this list, some get some more
ideas might show up once our many European members start posting in
volume. As a general aside, if you ever find yourself in this position
again, where you've got an urgent database problem, something y
if you have 40M rows and 10% are updated each day they
might all be on different pages. Also, it's not really the end of the
world if the FSM doesn't track every single page with free space -- as
long as it tracks enough to cover your usage until the next vacuum.
Thankfully all this is go
cently or still 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.pos
progress toward returning to where the right plan was preferred one.
The flip side 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
hen it comes 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.co
tabase you're considering with a many
clients going at once 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
y have PostgreSQL up and running.
--
greg
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Sat, Jan 31, 2009 at 5:34 PM, Octavio Alvarez
wrote:
>
> It doesn't really matter. Since crosstabs are just a presentational
> variation to a query with aggregate functions and GROUP BY clauses,
Why are crosstabs just a presentation issue any more than GROUP BY or ORDER
y the right thing for 8.3 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
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
--
Sen
he data passed to the function...
You need to make a subquery with the ORDER BY on it. Postgres won't
re-order an ORDER BY in a subquery to happen outside the outer query.
So something like
select perl_function(foo) from (select foo from table order by bar)
--
greg
--
Sent via pgsql-ge
I haven't thought hard about the pros and cons of adding more info to
pg_locks versus implementing redundant logic in SQL to mirror C code.
Neither seems terribly enticing offhand.
I wonder if anybody else has already implemented something like
lock_conflicts()?
--
greg
--
Sent vi
On Tue, 3 Feb 2009, Greg Stark wrote:
Notably, there's no indication of which lock wait queue the ungranted
locks are in. That means to find out what's blocking a lock would
require comparing every other lock to it and deciding whether it
conflicts.
The tool I find myself wanting
> Dunno. Could such a thing live in userland, or would it have to be
> compiled in?
Sure, it's just tedious and error-prone. You compare all the fields of
pg_locks and implement the same rules our locking code follows.
--
greg
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to mark tuples as
>> committed when inserting them into newly added pages without WAL:
>
> I'll take this for 8.5.
This was proposed once already and some difficulties were identified.
Do you remember what they were?
--
greg
--
Sent via pgsql-general mailing list (pgsql-genera
et 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
#x27;t know which Christopher was thinking of, apparently
not the latter based on his subsequent response. But in case anyone
else was or simply hadn't realized there were two different
conceptions of this I wanted to draw the distinction.
--
greg
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
tools, and also creates a huge
bottleneck.
--
greg
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
n to the manual 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
avoid all sorts of headaches is to use
pgloader: http://pgfoundry.org/projects/pgloader/ which 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.
--
ecords to
wipe out the cache. You can 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 subs
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
Shouldn't 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
stance <http://www.miracleas.com/BAARF/RAID5_versus_RAID10.txt>.
HTH,
Greg Williamson
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
n this case (like many of the other
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)
T
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
--
Sen
tgres/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 (
n about 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
901 - 1000 of 1768 matches
Mail list logo
