Laurence Rowe wrote
> I have WAL archiving setup on Postgres 9.3.2 using WAL-E on CentOS 6.4
> using the postgresql.org RPM. This is working fine, except I see a lot of
> spurious activity in the S3 bucket with wal files being backed up every 5
> minutes even when the database is idle. This can mak
>
>
> > > - What are the differences among PL/SQL, PL/PGSQL and pgScript.
> >
> > The first two are languages you write functions in. pgScript is simply
> an
> > informal way to group a series of statements together and have them
> execute
> > within a transaction.
> >
>
> AFAICT, this isn't true
Le 6 août 2014 18:47, "David G Johnston" a
écrit :
>
> Bill Epstein wrote
> > I've tried a variety of ways based on the on-line docs I've seen, but I
> > always get a syntax error on EXEC when I use only the line EXEC
statement
>
> You likely need to use "EXECUTE" in PostgreSQL
>
>
> >INFO:
I have WAL archiving setup on Postgres 9.3.2 using WAL-E on CentOS 6.4
using the postgresql.org RPM. This is working fine, except I see a lot of
spurious activity in the S3 bucket with wal files being backed up every 5
minutes even when the database is idle. This can make restoring to a dev
server
Phoenix Kiula wrote
> My PG server is still going down. After spending the weekend doing a
> CLUSTER of my largest table (it's a RAID 1 system with SATA hard disks
> and 4 GB memory, mostly devoted to PG) I still have this issue.
>
> When I do a "top" command, 99% of the CPU and about 15% of the m
Thank you for the very specific idea of pg_stat_user.
This is what I see (the output is also included in email below, but
this is easier to read) --
https://gist.github.com/anonymous/53f748a8c6c454b804b3
The output here (might become a jumbled mess)--
=# SELECT * from pg_stat_user_tables where
On Wed, Aug 6, 2014 at 6:30 PM, Tatsuo Ishii wrote:
> Another idea could be having our own collation data to isolate any
> changes from outside world. I vaguley recall this had been discussed
> before.
That's probably the best solution. It would not be the first time that
we decided to stop relyi
> Over time, collation order will vary: there may be fixes needed as
> more information becomes available about languages; there may be new
> government or industry standards for the language that require
> changes; and finally, new characters added to the Unicode Standard
> will interleave with th
My PG server is still going down. After spending the weekend doing a
CLUSTER of my largest table (it's a RAID 1 system with SATA hard disks
and 4 GB memory, mostly devoted to PG) I still have this issue.
When I do a "top" command, 99% of the CPU and about 15% of the memory
is being taken by PG. Wh
On Wed, Aug 6, 2014 at 5:11 PM, Bruce Momjian wrote:
> No surprise; I have been expecting to hear about such breakage, and am
> surprised we hear about it so rarely. We really have no way of testing
> for breakage either. :-(
I guess that Trip Advisor were using some particular collation that
On Wed, Aug 6, 2014 at 09:24:17PM +, Matthew Kelly wrote:
> The following is a real critical problem that we ran into here at TripAdvisor,
> but have yet figured out a clear way to mitigate.
>
> TL;DR:
> Streaming replicas—and by extension, base backups—can become dangerously
> broken
> when
The following is a real critical problem that we ran into here at TripAdvisor,
but have yet figured out a clear way to mitigate.
TL;DR:
Streaming replicas—and by extension, base backups—can become dangerously broken
when the source and target machines run slightly different versions of glibc.
On 08/06/2014 03:43 PM, Jorge Arevalo wrote:
Hello,
I want to connect to my local installation of PostgreSQL 9.1 using my
machine user (who is vagrant). So, after reading PostgreSQL
documentation, I thought I just needed to:
1. Add username map in pg_ident.conf:
# MAPNAME SYSTEM-USERNAME
On 8/6/2014 3:43 PM, Jorge Arevalo wrote:
I want to connect to my local installation of PostgreSQL 9.1 using my
machine user (who is vagrant). So, after reading PostgreSQL
documentation, I thought I just needed to:
wouldn't it be easier to ...
create user vagrant superuser;
creat
Looks like you're doing it right, you actually have to specify the user
though:
psql -U postgres
and make sure you restarted the server so your changes take effect.
Frank
On Wed, Aug 6, 2014 at 4:43 PM, Jorge Arevalo
wrote:
> Hello,
>
> I want to connect to my local installation of PostgreSQ
Hello,
I want to connect to my local installation of PostgreSQL 9.1 using my
machine user (who is vagrant). So, after reading PostgreSQL documentation,
I thought I just needed to:
1. Add username map in pg_ident.conf:
# MAPNAME SYSTEM-USERNAME PG-USERNAME
vp
On Wed, Aug 06, 2014 at 05:28:09PM -0400, Gregory Taylor wrote:
> We are working on a threaded comment system, and found this post by Disqus
> to be super helpful:
>
> http://cramer.io/2010/05/30/scaling-threaded-comments-on-django-at-disqus/
>
> The CTE works wonderfully, and we're really happy
We are working on a threaded comment system, and found this post by Disqus
to be super helpful:
http://cramer.io/2010/05/30/scaling-threaded-comments-on-django-at-disqus/
The CTE works wonderfully, and we're really happy with the results. The
last obstacle is figuring out how to sort by a "votes"
On Wed, Aug 6, 2014 at 10:08 AM, Jeff Janes wrote:
> On Tue, Aug 5, 2014 at 4:30 PM, David G Johnston <
> david.g.johns...@gmail.com> wrote:
>
>>
>> Anyway, you should probably experiment with creating a multi-column index
>> instead of allowing PostgreSQL to BitmapAnd them together. Likely the
On Aug 6, 2014, at 12:28 PM, Bill Epstein wrote:
> I'm very new to Postgres, but have plenty of experience developing stored
> procs in Oracle.
>
I found this helpful:
http://www.amazon.com/PostgreSQL-Server-Programming-Hannu-Krosing-ebook/dp/B00DMYO2D2/ref=tmm_kin_swatch_0?_encoding=UTF8&
On Tue, Aug 5, 2014 at 4:30 PM, David G Johnston wrote:
>
> NOTE: I am confused by this line:
> -> BitmapAnd (cost=291564.31..291564.31 rows=28273 width=0) (actual
> time=23843.870..23843.870 rows=0 loops=1)
>
> How did actual match zero rows? It should be something like 2.2M
>
The accounting
On Tue, Aug 5, 2014 at 2:08 PM, john gale wrote:
>
> >>-> Bitmap Index Scan on
> >> index_testruns_on_custom_spawnid (cost=0.00..41437.84 rows=500170
> >> width=0) (actual time=4872.404..4872.404 rows=2438520 loops=1)
> >
> > Ouch, ouch, and more ouch. Your index_testruns_on_cus
Bill Epstein wrote
> I've tried a variety of ways based on the on-line docs I've seen, but I
> always get a syntax error on EXEC when I use only the line EXEC statement
You likely need to use "EXECUTE" in PostgreSQL
>INFO: INSERT INTO UTILITY.BPC_AUDIT (COMPONENT, ACTIVITY, AUDIT_LEVEL,
>
I'm very new to Postgres, but have plenty of experience developing stored
procs in Oracle.
I'm going to be creating Postgres stored procedures (functions actually,
since I discovered that in postgres, everything is a function) to do a
variety of batch-type processing. These functions may or may
vpmm2007 wrote
> type function is record (f1 NUMERIC,f2 NUMERIC..); this is in oracle
>
> kindly tell me what is the substitute to use "is record " in postgres.
>
> its urgent .
>
> thanks and rgds
> vpmm
No idea on exactly what Oracle is creating here (a type or a set returning
function)
On Sun, Aug 3, 2014 at 3:20 AM, Phoenix Kiula
wrote:
> Hi. I've been patient. PG is 9.0.17, updated via Yum yesterday.
>
> One of my large tables (101 GB on disk, about 1.1 billion rows) used
> to take too long to vacuum. Not sure if it's an index corruption
> issue. But I tried VACUUM FULL ANALY
On 08/06/2014 03:50 AM, M Tarkeshwar Rao wrote:
Hi Team,
We are facing some inconsistence behaviour of Postgres. We have deployed
our database on a server where timezone is GMT+3 hours.
What Postgres version?
How was Postgres installed and on what OS?
We have application which is running on
Hi Team,
We are facing some inconsistence behaviour of Postgres. We have deployed our
database on a server where timezone is GMT+3 hours.
We have application which is running on the same server.
When application starts, it is inserting the correct timestamp in the table but
after running few mi
Hello,
> "index_testruns_on_custom_spawnid" btree ((custom_data -> 'SpawnID'::text))
> ..
> WHERE testruns.custom_data->'SpawnID' = 'SpawnID-428842195.338828'
> ...
If all your SpawnID have this prefix, you may consider remove it from your
index to reduce its size:
=> "index_testruns_on_custom
29 matches
Mail list logo
