any question or comments, please send to pgday-asia
[at] googlegroups.co.jp
Regards,
--
Satoshi Nagayasu <sn...@uptime.jp>
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
thought I'd try asking here before I
started to patch Postgres :)
See xlogdump if you use 9.2 or earlier.
https://github.com/snaga/xlogdump
If you're going to use 9.3, you can find pg_xlogdump in the contrib.
http://www.postgresql.org/docs/devel/static/pgxlogdump.html
Regards,
--
Satoshi Nagayasu
() in src/backend/storage/smgr/md.c.
That's the code which deals with segment files on extending a table,
and RELSEG_SIZE defines the segment size, 1GB by default.
Regards,
--
Satoshi Nagayasu sn...@uptime.jp
Uptime Technologies, LLC. http://www.uptime.jp
--
Sent via pgsql-general mailing list (pgsql
be shared?
Regards,
--
Satoshi Nagayasu sn...@uptime.jp
Uptime Technologies, LLC. http://www.uptime.jp
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
. :)
Regards,
--
Satoshi Nagayasu sn...@uptime.jp
Uptime Technologies, LLC. http://www.uptime.jp
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
will also look at MS Access as a query builder, although I'm not
familiar with the software so far.
Regards,
--
Satoshi Nagayasu sn...@uptime.jp
Uptime Technologies, LLC. http://www.uptime.jp
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
(2013/02/09 0:41), Adrian Klaver wrote:
On 02/08/2013 07:33 AM, Kevin Grittner wrote:
Satoshi Nagayasu sn...@uptime.jp wrote:
Of course, I can write ad-hoc queries by myself. However, I'd
like to allow non-tech people to issue ad-hoc queries with using
some visual query builder.
You should
BY with it.
Do you have any experience or recommendation about visual query builder
for PostgreSQL?
Regards,
--
Satoshi Nagayasu sn...@uptime.jp
Uptime Technologies, LLC. http://www.uptime.jp
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
2011/12/10 10:54, Greg Smith wrote:
On 12/08/2011 09:48 AM, Satoshi Nagayasu wrote:
For examples, I've been working on investigating PostgreSQL LWLock behaviors
precisely for a few weeks, and it could not be obtained within PostgreSQL
itself, therefore, I picked up SystemTap. However, SystemTap
2011/12/08 21:53, Tomas Vondra wrote:
- performance monitoring and diagnostics. It's way harder to find out
what's causing load on a busy Pg server or report on frequent/expensive
queries etc. Tooling is limited and fairly primitive. It's find, but
nowhere near as powerful and easy as some if
Hi Louis,
2011/10/27 19:49, mailtolouis2020-postg...@yahoo.com wrote:
Hi,
I'm sorry I'm not good in C, anyone can help to put a patch or release a new
version for that?
Regards
Louis
Hi,
2011/5/18 Tatsuo Ishii is...@postgresql.org:
How do you handle statements that rely on current_timestamp, random(),
etc? What about if their reliance is via a function? Is that just an
understood limitation of the cache, that it'll cache even queries that
don't really make sense to cache?
Hi,
2011/05/17 14:31, Adarsh Sharma wrote:
Rick Genter wrote:
On May 16, 2011, at 10:09 PM, Adarsh Sharma wrote:
Dear all,
I need to research on Memcache in the next few days.
What I want to know is it worth to have memcahed enable in our Mysql/ Postgres
Production Servers.
We have
Hi all,
I'm looking for some tricky way for tsearch query.
Now, I know when a tsvector column has an array ('a', 'b', 'c'),
tsquery ('ac') hits the row.
But I want to search rows with considering the order of tsvector
elements.
I want to hit a row when I use 'ab' or 'bc' in a tsquery,
but not
On 2010/12/26, at 21:35, sunpeng blueva...@gmail.com wrote:
so the writing speed on disk of pc is much faster than laptop, why the update
sql command is much slower than my laptop? what's the reason causing such
decrease?
Are those PostgreSQL versions and/or configurations completely same?
Hi Ben,
On 2010/12/22 7:46, Ben Carbery wrote:
FYI, not looking for a detailed how to here.. I have read the manual twice and
just can't figure which sections are relevant. The manual seems to be trying to
cover all uses simultaneously which is always going to get confusing :) For
example do
Hi Gavin,
On 2010/11/04, at 17:58, Gavin Burrows gavin_burr...@yahoo.com wrote:
I'm sure you have had this question many times before but I feel as though I
have genuinely exhausted all of my option and followed all the advise I can
find online.
During installation of Postgresql at the
On 2010/10/12 8:46, Carlos Mennens wrote:
Just wondering how you guys feel about NoSQL and I just wanted to
share the following article...
http://www.linuxjournal.com/article/10770
Looking to read your feedback and / or opinions.
Seems a nice article. I like it. :)
I think NoSQL is a new
These three queries may help you to understand what's going on.
EXPLAIN ANALYZE SELECT count(catalog.id) FROM catalog;
EXPLAIN ANALYZE SELECT count(catalog.id) FROM catalog WHERE flag=false;
EXPLAIN ANALYZE SELECT count(DISTINCT catalog.id) FROM catalog WHERE flag=false;
Regards,
--
NAGAYASU
On 2010/09/12 23:02, adi hirschtein wrote:
I'm coming from the Oracle side of the house and In oracle for instance, you
use shared buffer as well, but you are still able to see which session is
waiting for which blocks
and if one session is doing the real I/O then the other one wait on 'wait
Hi all,
I'm looking into some ecpg part of the official manual,
and I have found some strange things.
I'm now investigating SQLCODE and SQLSTATE, and I have found
that some of the errno definitions don't match to the manual.
For example, the manual says that ECPG_CONVERT_BOOL could be `-207'.
21 matches
Mail list logo