On 09/29/2017 09:32 AM, Tom Lane wrote:
Andy Colson writes:
I started playing with 10, and cannot get it to use the right version of perl.
I'll only use the system version:
root@firefly:/usr/local/pg10/lib/postgresql# ldd plperl.so
libperl.so => /usr/lib64/perl5/CORE/li
On 9/29/2017 9:28 AM, kbran...@pwhome.com wrote:
Andy Colson wrote:
In PG 9.5 this worked fine, and compiling and running PG used the 5.26 version
of perl:
root@firefly:/usr/local/pg95/lib/postgresql# ldd plperl.so
libperl.so =>
/opt/perl5/perls/perl-5.26/lib/5.26.1/x86_64-linux-thr
ad-multi/CORE -lperl -lpthread -lnsl -ldl -lm -lcrypt -lutil
-lc'
perl_privlibexp='/opt/perl5/perls/perl-5.26/lib/5.26.1'
perl_useshrplib='true'
Thanks for your time,
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Is there a way to find NAMEDATALEN in a
database, other than looking at the
source? If not could it be added to the
PG_CONFIG eventually?
Andy Johnson
On 04/25/2017 05:40 AM, Karri Niemelä wrote:
Hi. Wondering what sort of results are people seeing on modern servers when
running pg_test_fsync?
Thanks,
Karri
18 sata laptop hd's (some 5400, some 7200), hardware raid 10
12 core Xeon E5645
5 seconds per test
O_DIRECT supported on this platfor
On 04/25/2017 05:40 AM, Karri Niemelä wrote:
Hi. Wondering what sort of results are people seeing on modern servers when
running pg_test_fsync?
Thanks,
Karri
4 sata HD, hardware raid 10
4 core Xeon E5504
Box is Busy
5 seconds per test
O_DIRECT supported on this platform for open_datasync an
ids)
ON CONFLICT DO NOTHING"
PL/pgSQL function merge_users(integer[]) line 38 at SQL statement
I have provided more context at
http://stackoverflow.com/questions/43168406/merging-records-in-a-table-with-2-columns-primary-key
Also I have tried to create an SQL Fiddle at
http://sqlfiddl
much of the advanced features of
psql:
-Ken
I have to admit, I have typed \d at the sqlite3 prompt before. And I am being
forced to support a mysql database against my will, so I'll be trying this out.
Thanks!
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.or
PostGIS is to shapefile
as PostgreSQL is to csv
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ble never
have more than 24 hours worth of data, by_day goes back many years.
My stats pages all query the by_hour and by_day tables, and its very fast.
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
PostgreSQL platforms have been upgraded to 9.6. Or make it a dependency of the
application release that the PostgreSQL platform is 9.6.
Andy
From: Michael Paquier
Sent: 03 November 2016 09:35
To: Andy Halsall
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] li
schema live;
drop table live.junk2;
alter table work.junk2 set schema live;
.. about 200 more tables ...
commit;
works like a champ.
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
.9 "Client
Interfaces". I'd expect any un-changed features to be backwards compatible.
Limited testing suggests this is so but I can't find a clear statement.
Could somebody please advise?
Thanks
Andy
On 10/18/2016 11:44 AM, Francisco Olarte wrote:
On Tue, Oct 18, 2016 at 5:06 PM, Andy Colson wrote:
I wanted to report an awesome performance boost using tablesample.
In my stored function I was getting a random row using:
select one into x from ones order by random() limit 1;
When the table
around 8 transactions a
second.
I just replaced it with:
select one into x from ones tablesample bernoulli(1) limit 1;
And now I'm getting 376 transactions a second!
Thank you dev's! Thank you PG 9.5!
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.or
On 8/22/2016 2:39 AM, Thomas Güttler wrote:
Am 19.08.2016 um 19:59 schrieb Andy Colson:
On 8/19/2016 2:32 AM, Thomas Güttler wrote:
I want to store logs in a simple table.
Here my columns:
Primary-key (auto generated)
timestamp
host
service-on-host
loglevel
msg
json (optional
But its an hourly summary, which the
website turns around and queries the stats to show pretty usage graphs.
In the end, PG or ES, all depends on what you want.
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ogical slot and making a new one, and testing it
out, restart_lsn is progressing just fine.
Here is a bit of terminal history that shows the problem. Sorry for the
formatting (here is a pretty version http://pastebin.com/YgYuiR3U):
andy@katniss:~$ psql vcstimes
psql (9.5.3)
Type "help&
On 8/3/2016 8:27 PM, Andy Colson wrote:
Hi all.
I have a localdb and a remotedb.
A) I'd like to send table1 and table2 from localdb to remotedb.
B) I'd like to send table3 from remotedb to localdb.
I have PG9.5 and pglogical setup, and (A) works fine.
Well, worked. I then tried to
me=vcstimes user=postgres
slot_name | pgl_vcstimes_payroll_provider_subscribc0f4b85
replication_sets | {default,default_insert_only,ddl_sql}
forward_origins | {all}
I cannot find any description of status = down, and I don't know how to bring
it back up. Any help would be apprecia
On 07/03/2016 11:42 AM, Andy Colson wrote:
Now that I think about this more, I think you're on to something.
I'm trying to get an _exact_ copy of the master db onto the slave.
Checking rsync man, it matches only on size and modified time, and I
didn't include deletes.
I'm
On 07/03/2016 11:04 AM, Adrian Klaver wrote:
On 07/03/2016 08:49 AM, Andy Colson wrote:
On 07/03/2016 10:35 AM, Adrian Klaver wrote:
On 07/03/2016 08:06 AM, Andy Colson wrote:
Hi all,
I have a master (web1) and two slaves (web2, webserv), one slave is
quite far from the master, the db is 112
On 07/03/2016 10:35 AM, Adrian Klaver wrote:
On 07/03/2016 08:06 AM, Andy Colson wrote:
Hi all,
I have a master (web1) and two slaves (web2, webserv), one slave is
quite far from the master, the db is 112 Gig, so pg_basebackup is my
last resort.
I followed the page here:
https
On Sun, Jul 3, 2016 at 11:06 AM, Andy Colson mailto:a...@squeakycode.net>> wrote:
Hi all,
I have a master (web1) and two slaves (web2, webserv), one slave is quite
far from the master, the db is 112 Gig, so pg_basebackup is my last resort.
I followed the page here:
DT,: LOG: database system is ready to accept read
only connections
,,2016-07-03 06:06:57.984 CDT,: LOG: invalid record length at 369/DD038ED0
,,2016-07-03 06:06:58.344 CDT,: LOG: started streaming WAL from primary at
369/DD00 on timeline 1
web,[unknown],2016-07-03 06:07:11.176 CDT,[local]:
d 10 attached to a D2700 would be
performant at all?
There's a pretty good chance I'll get a few more. I might get 5 more, would
that make a difference?
Would the Supermicro and an HP D2700 use about the same amount of power?
Thanks all.
-Andy
--
Sent via pgsql-general mailing lis
On 06/17/2016 09:23 PM, Scott Marlowe wrote:
On Fri, Jun 17, 2016 at 2:36 PM, Andy Colson mailto:a...@squeakycode.net>> wrote:
Hi all.
I have access to quite a few laptop HD's (10 to 15 of them at least), and
thought that might make a neat test box that might have some go
On 06/17/2016 04:33 PM, Gavin Flower wrote:
On 18/06/16 08:36, Andy Colson wrote:
Hi all.
I have access to quite a few laptop HD's (10 to 15 of them at least), and
thought that might make a neat test box that might have some good IO speed.
Needs to be cheap though, so linux with sof
with anything like that? $2K might be
possible, painful, but possible.
Suggestions?
Thanks for your time,
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
. I just re-run it real quick and it works fine.
when you do your drop view, rename table, if you happen to get a
deadlock, I wouldnt worry too much. Just re-run it. Also, I'm still on
9.3 so maybe its not as much of a problem anymore.
-Andy
--
Sent via pgsql-general mailing list (
On 6/8/2016 2:57 PM, Ben Buckman wrote:
Thanks Andy.
My understanding, and please correct me if I'm wrong, is that the view
will effectively inherit the table's constraints, because writes to the
view that can't be written to the table will fail on the table. Re:
"will t
to the new table, will it be good data? Will the new app be ok with it?
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
please don't top post.
> Em 10/03/2016 16:56, Andy Colson escreveu:
On 3/10/2016 1:41 PM, Edson Richter wrote:
Hi!
Using async replication between geographically database servers. I've
some 9.3 and some 9.4 servers, so doesn't matter the version (the only
reason I've
a best practice for multi-database systems with async
replication to avoid such "resync" problems?
Thanks for your orientation,
I wrote about my setup here:
http://www.postgresql.org/message-id/548f3954.8040...@squeakycode.net
Would be happy to answer questions.
-Andy
--
Sent
On 02/13/2016 04:33 AM, Yury Zhuravlev wrote:
Andy Colson wrote:
cmake and make -j2 fine, but then
You can try again I removed some features from CMake 3.x .
Realy big thanks for testing!
My pleasure.
Still didn't work. 'make check' seems to make it through make inst
On 2/12/2016 9:47 AM, Yury Zhuravlev wrote:
Andy Colson wrote:
Is the installcheck important to you?
Hello!
You can try new make check. Also "make install" started support DESTDIR.
cmake and make -j2 fine, but then
andy@mapper:~/projects/postgres_cmake/build$ make chec
about the libs, but things like integer dates, and
perl, python, etc, ssl version. Looks like you calc TABLE_BLOCKSIZE and
WAL_BLOCKSIZE, those might be nice to see.
Anyway, thanks for all your work on this. Looking good.
-Andy
--
Sent via pgsql-general mailing list (pgsql-general
On 2/11/2016 10:44 AM, Andy Colson wrote:
On 2/11/2016 9:49 AM, Yury Zhuravlev wrote:
Yury Zhuravlev wrote:
I will try to fix soon.
I write as a corrected.
You can try again. Thanks!
That seems better:
-- Found Readline: /usr/include
-- Found Curses: /usr/lib64/libcurses.so
Is this bad
int64 - failed
-- Check size of uint64
-- Check size of uint64 - failed
-- Check size of int8
-- Check size of int8 - failed
make -j2
running now...
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
On 2/10/2016 2:50 PM, Andy Colson wrote:
On 2/10/2016 2:45 PM, Andy Colson wrote:
On 2/10/2016 12:09 PM, Yury Zhuravlev wrote:
Hello all.
Please test build Postgres using cmake. If you are of course interested.
Still not everything is ready but most of the work. Assembly
instructions as does
On 2/10/2016 2:45 PM, Andy Colson wrote:
On 2/10/2016 12:09 PM, Yury Zhuravlev wrote:
Hello all.
Please test build Postgres using cmake. If you are of course interested.
Still not everything is ready but most of the work. Assembly
instructions as does the repository is on github:
https
On 2/10/2016 12:09 PM, Yury Zhuravlev wrote:
Hello all.
Please test build Postgres using cmake. If you are of course interested.
Still not everything is ready but most of the work. Assembly
instructions as does the repository is on github:
https://github.com/stalkerg/postgres_cmake
The compilati
Its the
person running the select that pays the time for a huge delete. In PG,
there is a background vacuum task, so users don't pay the price.
Respect for FB, but my heart belongs to PG.
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Am 21.01.2016 um 03:33 schrieb Andy Colson:
On 01/20/2016 03:29 PM, Johannes wrote:
I noticed transferring a large object or bytea data between client and
server takes a long time.
For example: An image with a real size of 11 MB could be read on server
side (explain analyze) in 81ms. Fine.
But
d line (or at least something other than java), to see
if its java thats the problem.
3) watch wireshark/tcpdump, maybe you'll see something glaring that'll point
you in the right direction.
-Andy
PS: I've never heard that ssl compression was a security risk, got links/proof?
On 1/14/2016 2:06 PM, David G. Johnston wrote:
select regexp_replace('71.09.6.01.3', '(\d)[.-](?=\d)', '\1\2', 'g');
Thanks David!
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
<><
John McKown
Yes, excellent, both seem to work. I'll run a bunch of data through
them both and see what happens.
Thanks much for the help!
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 1/14/2016 1:59 PM, Tom Lane wrote:
Andy Colson writes:
This is not doing as I'd expected:
select regexp_replace('71.09.6.01.3', '(\d)[.-](\d)', '\1\2', 'g');
regexp_replace
71096.013
(1 row)
I think regexp_replace
12-34-56 has caught on fire")
I seem to be missing something, any hints?
I'm on PG 9.3.9 on Slackware64.
Thanks for your time,
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Sorry. I just saw the reference to this in the related thread.
On Jan 11, 2016 7:01 PM, "Andy Chambers" wrote:
> Any reason not to just adopt the contributor covenant?
>
> http://contributor-covenant.org/
> tl;dr;
>
> * Removed #6 (Social Justice)
>
> Postgre
Any reason not to just adopt the contributor covenant?
http://contributor-covenant.org/
tl;dr;
* Removed #6 (Social Justice)
PostgreSQL Global Development Group (PGDG) Code of Conduct (CoC):
1. The CoC is to provide community guidelines for creating and enforcing a
safe, respectful, productive,
up
front, 5 web servers behind it. I'd bet its way faster.
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
,3,4,5} ) a
cross join unnest( {1,2,3,4,5} ) b
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 12/30/2015 2:39 PM, Andy Colson wrote:
On 12/30/2015 2:33 PM, Tom Lane wrote:
Andy Colson writes:
On 12/30/2015 2:18 PM, Tom Lane wrote:
Maybe something weird about the build you're using? What does
pg_config print?
[ output ]
No smoking gun there either.
It might be worthwhi
On 12/30/2015 2:33 PM, Tom Lane wrote:
Andy Colson writes:
On 12/30/2015 2:18 PM, Tom Lane wrote:
Maybe something weird about the build you're using? What does
pg_config print?
[ output ]
No smoking gun there either.
It might be worthwhile to update to 9.3.10, just in case the
On 12/30/2015 2:18 PM, Tom Lane wrote:
Andy Colson writes:
On 12/30/2015 1:55 PM, Tom Lane wrote:
Are you using any nondefault planner settings? Anything else
unusual about your installation?
There are others, but I'll bet its:
random_page_cost = 1
Nope...
Maybe something weird
On 12/30/2015 2:03 PM, Andy Colson wrote:
On 12/30/2015 1:55 PM, Tom Lane wrote:
Andy Colson writes:
On 12/30/2015 1:07 PM, Tom Lane wrote:
it seems like you've got some weird data statistics that are causing a
misestimate. Could we see the pg_stats row for that tsvector column?
Or
On 12/30/2015 1:55 PM, Tom Lane wrote:
Andy Colson writes:
On 12/30/2015 1:07 PM, Tom Lane wrote:
it seems like you've got some weird data statistics that are causing a
misestimate. Could we see the pg_stats row for that tsvector column?
Or maybe even the actual data?
The table exis
Wow thats bad.
Here's another link:
http://camavision.com/dn/stats.txt
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 12/30/2015 1:07 PM, Tom Lane wrote:
I wrote:
This says there's only about a 25% runtime penalty for the partial match,
at least on your example, compared to the planner's estimate of 2700x
penalty :-(. Definitely need to fix that.
I tried to reproduce this behavior with simple generated da
On 12/30/2015 10:09 AM, Tom Lane wrote:
Andy Colson writes:
-> Bitmap Index Scan on search_key (cost=0.00..6.00 rows=1 width=0)
(actual time=0.025..0.025 rows=0 loops=1)
Index Cond: (search_vec @@ to_tsquery('213 & E & 13 & ST & N'::text))
On 12/30/2015 9:55 AM, Andy Colson wrote:
On 12/30/2015 9:53 AM, Tom Lane wrote:
Andy Colson writes:
Here are my results, if there are any others you'd like to see please
let me know. Thanks Tom.
For comparison, could we see the results for the non-partial case, ie
explain analyze
s
On 12/30/2015 9:53 AM, Tom Lane wrote:
Andy Colson writes:
Here are my results, if there are any others you'd like to see please
let me know. Thanks Tom.
For comparison, could we see the results for the non-partial case, ie
explain analyze
select *
from search
where searc
On 12/29/2015 6:35 PM, Tom Lane wrote:
Andy Colson writes:
I cannot get this sql to use the index:
explain analyze
select *
from search
where search_vec @@ to_tsquery_partial('213 E 13 ST N')
--
Seq Scan
ied
that as a hard-coded value?
Ahh! Yep, that was the missing link. Jeez, I can't believe I couldn't
find it. The :* is for matching partials, its even IN the name
to_tsquery_partial.
Indeed, this does not use an index:
explain analyze
select *
from search
where search_vec @
Removed by Filter: 76427
Total runtime: 677.548 ms
(4 rows)
to_tsquery_partial() calls to_tsquery() and array_to_string(), both of
which I checked, and all of them are marked as stable.
Any hints why this is happening?
Thanks,
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
user logout or other session termination (timeout
counts too).
Does PostgreSQL perform this type of actions? If so, where are those Session
IDs are stored, so I can verify it?
Thanks,
Oleg
Are you talking about a website session? Does this website session happen to
be stored in PG?
-Andy
--
you tried Redis? Its really good at that sort of thing.
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 10/30/2015 05:10 PM, David Blomstrom wrote:
Just so I understand what's going on, I can create a lookup table by pasting
this code...
I don't know anything about biology so this data might be laughable, but its
based on your original question:
http://stackoverflow.com/questions/33402831/
onid as integer, then fill the spreadsheet column with int's, and
import both columns.
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 10/30/2015 4:36 PM, Andy Colson wrote:
On 10/30/2015 3:47 PM, David Blomstrom wrote:
No, I get the same T_FUNCTION error.
Someone commented that the function...
create function tax_rank(id integer) returns text as $$
select case id
when 1 then 'Cl
not. It should probably be a lookup table:
create table taxon (
taxonid serial,
descr text
);
create table gz_life_mammals (
id serial,
taxonid integer, -- use the lookup table
parentid integer -- use the lookup table
);
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
union all
>select m.taxon, m.parent_id
>from hier, gz_life_mammals m
>where m.parent=hier.taxon
> )
> select tax_rank(parent_id),
> count(*) num_of_desc
> from hier
> where parent_id is not null
> group by parent_id
> order by parent_id;";
$result =
On 09/01/2015 08:46 PM, Andy Colson wrote:
On 09/01/2015 07:00 PM, Bruce Momjian wrote:
On Tue, Sep 1, 2015 at 06:56:11PM -0500, Andy Colson wrote:
I also added a mention that rsync, not pg_upgrade, will be run on the
standbys. You can see all the results of the patch here:
http
On 09/01/2015 07:00 PM, Bruce Momjian wrote:
On Tue, Sep 1, 2015 at 06:56:11PM -0500, Andy Colson wrote:
I also added a mention that rsync, not pg_upgrade, will be run on the
standbys. You can see all the results of the patch here:
http://momjian.us/pgsql_docs/pgupgrade.html
Thanks
On 09/01/2015 04:09 PM, Bruce Momjian wrote:
On Sun, Aug 23, 2015 at 09:45:50AM -0500, Andy Colson wrote:
I think we should add a step 6.5 (before step 7 Stop both servers) with
something like:
If you are upgrading both a primary and standby, then we need to make sure the
standby is caught
down the standby make sure it gets caught up to the primary.
I don't think its 100% required for them to be exact, is it? If they are a
little different then rsync has more data to xfer from primary to standby ...
but it would still work. Right?
-Andy
--
Sent via pgsql-general mailing
ot less desirable that a simple warning.
Therefore, I am trying to educate the developers in the proper method of
escaping strings,
instead of loading up the error log with annoying warnings.
Please dont top post.
But you are not educating them correctly. Using E'' isnt right. Th
/pub/pg93|grep "Latest
check"
Latest checkpoint location: 1D1/AF60
So these numbers dont match, so that that mean:
1) I compared the wrong ones
2) Its broke, dont go any further
3) Its fine, rsync away
Thanks for your time,
-Andy
--
Sent via pgsql-general mailing list (pgsql
imary and new_pgdata refers to the new pg on the
standby? Is that even right? Any chance we could get examples of
setting old/new_pgdata?
Thanks all on another great release!
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ff
Have you looked at pg_bouncer? You'd have to make changes to the
source, but it's got a bunch of what you'd need. It sits in the middle
and could swap out text pretty easy. I'd guess.
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
On Tue, Jul 14, 2015 at 8:59 AM, Andy Colson mailto:a...@squeakycode.net>> wrote:
On 7/13/2015 7:08 PM, Ryan King - NOAA Affiliate wrote:
Apologies ahead of time for not knowing which group to send to,
but I
wanted to see if anyone has encountered and resolve
On 7/14/2015 1:19 PM, Marc Mamin wrote:
On 7/9/2015 12:41 PM, Tom Lane wrote:
Andy Colson writes:
My question is: Will PG cache only the index (assuming it can
always do an Index Only Scan), or will it cache the table as
well?
I'm not sure that indexes on tiny tables are useful.
m getting no where. I think ultimately the solution is
to upgrade, but the devs may not be ready for an upgrade at this point.
Any help would be greatly appreciated. Thanks!
You don't want to decrease kernel.shmmax you want to set it to the
request size:
sysctl -w kernel.shmmax=1146945536
sh
On 7/9/2015 1:04 PM, Sheena, Prabhjot wrote:
Guys
Is there a way to get total count of queries hitting
Postgresql DB(verison 9.3) per day or per hour ? I cannot turn on
log_statement=all coz that’s too much logging for our log file to
handle. Is there another way to do that.
Than
On 7/9/2015 12:41 PM, Tom Lane wrote:
Andy Colson writes:
My question is: Will PG cache only the index (assuming it can always do
an Index Only Scan), or will it cache the table as well?
The table blocks would fall out of cache if they're never touched.
regards
On 7/9/2015 11:24 AM, Ramesh T wrote:
Hi,
in oracle regexp_like(entered
date,'[[:digit:]]{4}-[[:digit:]]{2}-[[:digit:]]{2}','i')
for postgres i have regexp_matches ,But i need how to match [:digit:] in
postgres when we pass date..?
any help
\d
per:
http://www.postgresql.org/docs/de
I'd like to try to cut that down to either 5000 tables, or 5000 indexes
(not both).
Thanks for your time,
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi,
So the basebackup pulls the data directory over from the master.
I am pulling over anther copy of the data directory using basebackup
On 07/01/2015 05:51 PM, Andy Erskine wrote:
> If i grep for errors i get some invalid page header in block 56072 of
> relation base/16385/77373
If i grep for errors i get some invalid page header in block 56072 of
relation base/16385/77373 errors.
But not sure what else to look for ?
On 2 July 2015 at 10:41, Adrian Klaver wrote:
> On 07/01/2015 05:20 PM, Andy Erskine wrote:
>
>> I initially populated the directory using ba
I initially populated the directory using basebackup and pulled the data
directory across from the master.
On 2 July 2015 at 10:13, Adrian Klaver wrote:
> On 07/01/2015 05:04 PM, Andy Erskine wrote:
>
>> the cmd you listed did work it didn't like the -d option
>>
&
348K./archive_status
79G .
On 1 July 2015 at 23:59, Adrian Klaver wrote:
> On 07/01/2015 06:56 AM, Andy Erskine wrote:
>
>> /opt/database on both servers has been assigned 250gb only postgres has
>> been installed on them.
>>
>> I cannot get the output you requeste
I have db of 123GB Currently and this is streaming to a secondary DB which
also shows a size of 123GB (Using pgAdmin)
The db's both reside on a 250GB directorys and on the Master i'm using 60%
of capacity which seems expected
On the secondary i am using 88% of the disks capacity. I assume this is
Cheers all.
On 30 June 2015 at 15:58, John R Pierce wrote:
> On 6/29/2015 10:55 PM, Andy Erskine wrote:
>
>> agreed there is an element of risk.
>>
>> however a backup of the master will be carried out prior (ok there could
>> potentially be a gap of data during d
t; On Tue, Jun 30, 2015 at 2:29 PM, Andy Erskine
> wrote:
>
>> Ok so a question i should have asked at the very beginning ..
>>
>> If i touch my trigger file - promoting the secondary to a master - will
>> that in anyway effect the master thats already running ?
&
i've finished and
run the basebackup process again to restore replication (and change
recovery.done - conf again.
thanks.
On 30 June 2015 at 15:22, Michael Paquier wrote:
>
>
> On Tue, Jun 30, 2015 at 1:39 PM, Andy Erskine
> wrote:
>
>> No i don't want a replica.
ing.
When i've finished testing - i want to reconfigure for streaming again.
On 30 June 2015 at 12:37, Tomas Vondra wrote:
> Hi,
>
> On 06/29/2015 09:27 AM, Andy Erskine wrote:
>
>> Thanks Jeff,
>>
>> I don't want a clone - i want to temporaily turn
eral mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
*Andy Erskine*
*JDS Australia*
*P* 1300 780 432 | *M* 0431919301 | *F* 03 90124578
*E:* *andy.ersk...@jds.net.au *
*W*: www.jds.net.au
Level 8, 2 Russell Street, Melbourne, VIC 3000
GPO Box 4777, Melbourne VIC 3001
[image: JDS Signature v1]
:50, Michael Paquier wrote:
>
>
> On Mon, Jun 29, 2015 at 3:34 PM, Andy Erskine
> wrote:
>
>> no snapshot available .. i don't mind running basebackup once i've
>> finished my test.
>>
>> So if someone could help with the steps to turn off replica
es up.
>
>
>
> --
> john r pierce, recycling bits in santa cruz
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
*Andy
1 - 100 of 720 matches
Mail list logo
