mments, please send to pgday-asia
[at] googlegroups.co.jp
Regards,
--
Satoshi Nagayasu
--
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,
--
Satosh
e mdextend() 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
Uptime Technologies, LLC. http://www.uptime.jp
--
Sent via pgsql-general mailing
ce which can be shared?
Regards,
--
Satoshi Nagayasu
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
S) someday. :)
Regards,
--
Satoshi Nagayasu
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
(2013/02/09 0:41), Adrian Klaver wrote:
On 02/08/2013 07:33 AM, Kevin Grittner wrote:
Satoshi Nagayasu 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 probably t
te your SQL. It does allow for group by's, counts, etc.
Yeah, I will also look at MS Access as a query builder, although I'm not
familiar with the software so far.
Regards,
--
Satoshi Nagayasu
Uptime Technologies, LLC. http://www.uptime.jp
--
Sent via pgsql-general mailing lis
r I can use GROUP BY with it.
Do you have any experience or recommendation about visual query builder
for PostgreSQL?
Regards,
--
Satoshi Nagayasu
Uptime Technologies, LLC. http://www.uptime.jp
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to you
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, Syst
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 the
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 :
>> 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?
>
> Probably
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 databa
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 ('a&c') 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 'a&b' or 'b&c' in a tsquery,
but no
On 2010/12/26, at 21:35, sunpeng 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?
How about shared_b
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 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 time when it tries t
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 im
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 Sat
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'.
Ho
21 matches
Mail list logo