er of rows deleted, you should also:
vacuum full bucardo.syncrun;
The data in that table is not critical to Bucardo running - it is mostly
used for the output of "bucardo status" and for auditing of past syncs.
P.S. Bucardo has its own mailing list: bucardo-gene...@bucardo.org,
which in gener
d skills
to get a new release out (myself, Andrew D., Peter E., probably others).
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201710150923
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
--
Tom,
would you like a bug report to track this?
On Sat, Jul 22, 2017 at 07:00:03PM -0400, Tom Lane wrote:
> Greg Atkins writes:
> > I have a DB with an event trigger, which I am dumping with
> > pg_dump -Fc --no-acl --no-owner [db_name] > [dump_file]
>
> > In my
I have a DB with an event trigger, which I am dumping with
pg_dump -Fc --no-acl --no-owner [db_name] > [dump_file]
In my dump file, I can't find any DROP EVENT TRIGGER statement.
In src/bin/pg_dump/pg_dump.c, dumpEventTrigger() calls ArchiveEntry() with a ""
argument for the dropStmt parameter.
ical copy
of the affected tables (i.e. with indexes) but just a data-only copy:
create table dev.users as select * from public.users;
pg_dump herokudb --schema-only | psql devdb
pg_dump herokudb --data-only -T public.users | psql devdb
psql devdb -c 'insert into public.users select * from dev.user
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
cool to have it
> directly in Perl.
Well if you end up writing something, please throw it into CPAN so we
can all benefit. :)
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201701021822
http://biglumb
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
d envision some workarounds, but it
really depends on exactly what the OP is trying to achieve.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201610191401
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGI
by 1 limit
%s) TO STDOUT' | psql testdb -c 'COPY %I FROM STDIN' $$, table_name, 100,
table_name)
from information_schema.tables where table_schema = 'public' and
table_type = 'BASE TABLE';
psql> \q
$ sh dump.some.rows.sh
- --
Greg Sabino Mullane g...@turn
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
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!
. :)
What really bites is the analyze afterwards. That's the part
that takes too long (yes, --in-stages helps some). Would love
to see progress made there.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 20160727222
so:
https://www.mediawiki.org/wiki/How_to_become_a_MediaWiki_hacker
https://phabricator.wikimedia.org/T2384 (Postgres support tracking)
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201607191015
http://biglumber.com/x/web?pk=2529DF6AB8F79407E944
"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.
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
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
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
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
<
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/>
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.
>
&
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/>
``
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/>
then you can use pg_dump | psql for the rest.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201605272040
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
f this issue pops up anywhere else. Leaning towards the latter,
as I'm sure the planner *usually* does better with all options enabled. :)
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
signature.asc
Description: PGP signature
pearance of
nested loop *earlier* a few days.
Changing cpu_tuple_cost moves it forward a bit, but not enough to cover the
actual use case (now() - 1 month).
Leaving out the 'analyze' results in a much better plan, but having the tables
stay unanalyzed does not seem
like a
ts. I think this may indeed be one of those times
that we do not attempt to "roll our own". Or at the very least, we should
strive to understand how other communities arrived at their Codes and
why it is working for them.
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key
fforts in this.
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8 201601181316
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAladLAkACgkQvJuQZxSWSsjOZwCgqKxe5Uw9ujJIwCzWj4YHfVm9
etQAmwa1R5P8iPONXCgV9OMDiAaaTu/5
=awg
own.
Needed? I know part of a code of conduct is stating the obvious, but...
> 6. The CoC is not about Social Justice.
Really no need for this. Defensive, and introduces a loaded term.
Thanks, JD, for pushing this forward.
- --
Greg Sabino Mullane g...@tur
this same thing recently. I disagree that
it is a waste of time, but I'm happy if we get one, regardless
of different people's rationales for it.
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8 201601051213
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B90671496
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
uld be improved.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201507270953
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAlW2OAEACgkQvJuQZxSWSsj1CgCeKU8QO2dEHgBV6Su9D2eJmIss
MT
ed, then try again. If you don't know which tables are being used,
I suggest storing that somewhere your class can find it, or moving away
from such a generic class.
There are other solutions (e.g. forcing conflicting processes to quit
and sleep a second), but the locking one seems the
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
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[
ased, not statement at all. It stores up
a list of affected rows, then COPYs those from the source databases
to the target ones. It's particularly strong when you have large
delays and many updates to the same row.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.end
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
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
better way is to use
the session_replication_role feature. See:
http://blog.endpoint.com/2015/01/postgres-sessionreplication-role.html
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201502271149
http://biglumbe
binK_rPgnIklP.bin
Description: charset
There is BDR (Bi-Directional Replication) from 2ndQuadrant available in 9.4.
http://2ndquadrant.com/en/resources/bdr/
-Greg
On Wed, Nov 26, 2014 at 11:09 AM, Leonardo Carneiro
wrote:
> It look's like you're searching for Postgres equivalent of Oracle RAC. I
> don't
lly given the tradeoff
in complexity. Still, if the majority of the time is spent moving old
data from one or more tables, you could exclude those from the pg_dump
with -T, then copy over some small subset of the table with a pair of
COPY commands from prod to dev.
- --
Greg Sabino
ur
layout, usage pattern, network speeds, etc.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201408240939
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAlP5/9
red_xacts"?
If it's really corruption --which still seems a bit odd to me-- You
might find a simple vacuum or vacuum freeze on the table fixes up the
problem.
--
greg
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
and you haven't provided enough information to think that was the
case.
--
greg
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
hen the
postgresql.conf is created via initdb.)
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201404181453
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAlNRdVkACgkQv
d
in such a bug.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201404171231
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAlNQAe8ACgkQvJuQZxSWSshObwCglozBhwT4ddf7XacITK
e request
for 10,000 rows to libpq rather than call PQgetResult 10,000 times, but
we'll move ahead with implementing RowCacheSize via PQsetSingleRowMode.
- --
Greg Sabino Mullane g...@turnstep.com
PGP Key: 0x14964AC8 201404021428
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC
ce or SystemTap.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201402081451
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAlL2itEACgkQvJuQZxSWSshlIgCgo+jkIYojwc23O4jw
ies".
Bucardo and Slony are both table-based and trigger-driven.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201312100859
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
On Wed, Nov 6, 2013 at 4:36 AM, Leonardo Carneiro wrote:
> I don't think that there will be too much trouble, as long as you follow
> every changelog tip (9.0->9.1, 9.1->9.2 and 9.2->9.3)
>
>
What if we don't follow the changelog tip? In this case, we have only the
9.0 and 9.3 binaries installed a
major version along the way.
Cheers,
Greg
o from Postgres to Oracle.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201308262157
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAlIcB6AACgkQvJuQZx
numwords(int)
> returns text
> language plperlu
> immutable
> as '
> use Lingua::EN::Inflect qw( NUMWORDS );
> return NUMWORDS(shift);
> ';
> eot
CREATE FUNCTION
$ psql -tc 'select numwords(1234)'
one thousand, two hundred and thirty-four
ser functions some brains, such that
they will not execute when session_replication_role is set to 'local', for
example.
While I do think session_replication_role needs some more granularity, it's
also a little hard to say more without knowing your exact requirements.
- --
Greg Sabi
,
Greg W.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
d if you have a dump from 9.1 or older, you can use this script
to divide it up into the same sections:
http://bucardo.org/wiki/Split_postgres_dump
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201304081134
little
more involved. See:
http://www.postgresql.org/docs/9.2/static/plperl-under-the-hood.html
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201303271036
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906
On 17 Mar 2013, at 04:30, Tom Lane wrote:
> Oleg Alexeev writes:
>> * it is varchar columns, 256 and 32 symbols length
>> * encoding, collation and ctype: UTF8, en_US.utf8, en_US.utf8
>> * autovacuum, fsync off, full_page_writes = on, wal_writer_delay = 500ms,
>> commit_delay = 100, commit_sibl
On 13 Mar 2013, at 13:26, Shaun Thomas wrote:
> On 03/12/2013 05:49 PM, Gregg Jaskiewicz wrote:
>
>> So out of 6 disks then having 4 in Raid 1+0 configuration and other
>> two in mirror for WAL. That's another option then for me to test.
>
> That is an option, but it's not necessarily a good
Thanks for the link / explanation -- hadn't seen this use before.
GW
- Original Message -
> From: Adrian Klaver
> To: Greg Williamson
> Cc: "pgsql-general@postgresql.org"
> Sent: Wednesday, March 6, 2013 3:13 PM
> Subject: Re: [GENERAL] ERROR: synta
syntax error at or near ":"
>LINE 1: update property set value = :'content' where key = 'patricia...
> ^
>
The colon (":") is not needed, just remove it. A pair of colons is used to
indicate a cast of a value; off hand I am not coming up with
Hi all,
I've been working on a Dart library for querying postgresql.
If you're curious, have a go and let me know how it goes.
https://github.com/xxgreg/postgresql
Support for Heroku is coming soon.
Cheers,
Greg.
On 4 Mar 2013, at 13:21, Vincent Veyron wrote:
>
> There is this :
>
> http://wiki.postgresql.org/wiki/Postgres-XC
>
>
> [Disclaimer : I can't tell whether it's usable or not; I just know they
> exist]
>
Well, I know of its existence too. Question is how production ready is it. And
also
columns.
>
> Surely this has been done thousands of times. What are the thoughts
> regarding best practices in PG?
I handle this using middleware outside the db. Past revisions of a
record (from any table I want to track) are serialized into a JSON
format and stored in a single table. Postgres
urt to think I may have to turn off
auto-commit and manually commit transactions all throughout my code :(
Still hoping it's a pgpool setup issue, since it's my first time
setting it up and all.
Thanks.
--
Greg Donald
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.
em to be reliable for PostgreSQL. Those are expected
to be significantly cheaper than the 710 models, while having the same
reliability characteristics. I haven't been able to get one yet though,
so I don't really know for sure how well they perform.
--
Greg Smith 2ndQuadrant USg...@2
in that one, and then create your new databases using the "WITH TEMPLATE
= " option in CREATE DATABASE. So if you have need of different schemas with
different databases, that would be more extensible by making new templates,
onjhe3 for each type./.
HTH,
Greg Williamson
--
Sent via p
RCHAR(64), it doesn't matter if an existing
client sees that change or not - the data will still be stored exactly the
same. You can always put a heavy lock on pg_attribute to ensure everyone
sees the change.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint
p://blog.endpoint.com/2012/11/postgres-alter-column-problems-and.html
- --
Greg Sabino Mullane g...@endpoint.com g...@turnstep.com
End Point Corporation 610-983-9073
PGP Key: 0x14964AC8 201211300113
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
---
this
> change was not thought through completely.
On the contrary, it was very well discussed and designed. Why do you
even care if the anyone is listening or not? Simply remove the
"check if anyone listens" step and send the NOTIFY.
If you really need to know if anyone is liste
esn't. Thus, if
log_duration is on and log_min_duration_statement has a positive value, all
durations are logged but the query text is included only for statements
exceeding
the threshold. This behavior can be useful for gathering statistics in
high-load installations."
- --
Greg Sabin
u care about how fast sub-10ms mods
ran?
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201211292253
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEG
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Igor Neyman asked:
[Postgres 9.2]
> How (if it's even possible) can I get listening channels
> for all sessions/ connections in the database?
No, this is not possible. You can only see items
from your own session.
- --
Greg Sab
input, which warrants more than a notice IMO.
Separately, what are the objections to raising the size limit to 128?
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201211211525
http://bi
ard limit and ERROR instead of truncating and NOTICE?
> Both? Neither because that would break backward compatibility?
My vote is WARNING and bump limit to 128 in 9.3. That's the combo most
likely to make dumb applications work better while not breaking
existing smart ones.
- --
Gr
e tanks; when the site has issues we sometimes
see table bloat but it seems to be dealt with by autovac.
This is a postgres 9.1 instance w/ SSDs, lots of RAM (24 gigs) and relatively
small tables (maybe a few thousands of rows in most cases, total footprint of
the database is 240 megs) and being
ase cost limit. If you get
>to something in the 5000 to 1 range, and its still not keeping up
>then start bumping the thread count
>
Thanks for outlining a strategy on this -- useful advice.
Greg Williamson
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To m
t; 'i'
AND nspname !~ '^pg_toast'
AND relpages > 100
ORDER BY pg_total_relation_size(C.oid) DESC
LIMIT 20;
On my trivial test install that gives me just the one user table:
relation | total_size
------+
public.t | 3568 kB
While still showing large
issues on the master with
dead file handles but the replication itself is rock solid.
Greg
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
d drives still on the market I know of that pass a
serious test. The other good models are direct PCI-E storage units,
like the FusionIO drives.
--
Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.com
--
Sent
material outside of
the manual and distribute them to the world than to add 40 pages to the
official manual. And I say that as someone who tried wandering down
both paths to see which was more productive.
--
Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD
PostgreSQL Train
ce Postgres v6.
(Looking back at how far Postgres has come from 6.x to 9.2
is truly awe-inspiring)
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
pgp5oFeJLefSg.pgp
Description: PGP signature
x27;)))
Heap Fetches: 0
-> Index Scan using baz_id on baz (C=0..101 R=40 W=22) (AT=0.1..0.2 R=7 L=1)
Index Cond: ((o.id) = (id))
Filter: (price <> 0::numeric)
Rows Removed by Filter: 3
Total runtime: 34502.670 ms
Yeah34 seconds versus near-in
and
> the seqscan plan in 9.2.
Thanks, I will play around with both a better test case and getting some
explain analyzes (they were taking too long to run; thought I should get
the email out first in case it was something obvious).
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
pgpn2mbk5zwEr.pgp
Description: PGP signature
rimary key on foo, and an index named
index_i on foobar(status, foo). In another variation of the query,
8.3 uses foobar_pkey as well, rather than index_i, and filters that.
Matter of fact, index_i is never used.
At any rate, the change causes the original query to run much, much
slower. Problem on
You might look at the GIS extension, PostGIS: <http://postgis.refractions.net/>
Not sure how much yu need to do, but a company I used to work for ran a WMS
service off of an earlier version of postGIS.
Buena Suerte!
Greg Williamson
>
> From: José
mply not use pgpass, and find some other means to authenticate.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201210011859
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-
ed. Remember in general to add a /o to the end of your
regex if the first part is constant to avoid unneeded recomplilation.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201209131324
http://biglumber.com/
Prashant --
I haven't tried this -- we don't use DBI currently -- but wouldn't it get
treated as any other connection if you point the DBI connection to the
pgbouncer host / port / database ? pgbouncer should redirect the query
according the rules in its .ini file.
HTH,
l libraries are those?
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201207121257
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAk//AlQACgkQvJuQZxSWSsj6IACgzQJlK5Y1u
s against our
philosophy of being safe, careful, and correct.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201206200945
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEY
ly if you are using psql in
interactive mode. In other words, we already have an elegant and
lightweight approach to the described problem.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201206191146
ht
Toby --
A small point:
<...>
>How about something like
>
>use File::Slurp;
>use Try::Tiny;
>
>try {
> $dbh->being_work;
$dbh-begin_work;
<...>
Clarification for any who might be unfamiliar with the perl tools.
Greg Williamson
--
Sent via pgsql
t subject at
http://notemagnet.blogspot.com/2008/08/linux-write-cache-mystery.html
and http://blog.2ndquadrant.com/tuning_linux_for_low_postgresq/ (note
that some of the links in that second one, to the test pgbench results,
are broken; http://www.highperfpostgres.com/pgbench-results/index.htm is
ERROR: operator does not exist: character varying == character varying
>
>and provides the hint to add explicit type casts. Since the string length of
>site/siteid varies I don't see how to cast both to a working type.
>
> Please suggest how I can populate this table while av
It may vary from version of postgres to version, but perhaps you are seeing the
effects of TOAST kicking in ? Do a search in the documentation for your
specific version (8.3, 9.1 etc.)
HTH,
Greg Williamson
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
Greetings,
I am trying to get the source XML file for the PostgreSQL installer. This is
the BitRock InstallBuilder XML file.
Can anyone direct me to the proper place to obtain this installer file?
Thank you,
Greg
anything that goes cross-database
is subject to lots of very careful care and handling, and I doubt adding
that complexity is worth the small benefit gained.
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 2012
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
1 - 100 of 1774 matches
Mail list logo
